News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
How to Use Join without a Common Column Name in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 # Advance Data Analysis #Join in DataFrame import pandas as pd df1=pd.DataFrame({'empname':['rahul','vijay','dipesh'],'Age':[45,43,54]}) df2=pd.DataFrame({'citizen':['rahul','vijay','amit'],'Salary in lakhs ':[23,33,28]}) # Outer Join df3=pd.merge(df2,df1,left_on='citizen',right_on='empname',how='inner') print(df1)...
Insert, Delete and Update Command in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 import pandas as pd emp=pd.read_excel("D://mypandas/employee.xlsx") print(emp) # Delete # emp=emp.drop(emp[emp.gender=='male'].index) # # emp=emp.drop(emp[emp.totalsalary==10000].index) # print(emp) # Update # #emp.loc[emp['totalsalary']==7000]=7600 # emp.loc[emp['totalsalary']==15000,'totalsalary']=25000...
How to Use SQL in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 import pandas as pd emp=pd.read_excel("D://mypandas/employee.xlsx") #print(emp.nlargest(5,columns='totalsalary')) #print(emp.nlargest(5,columns='totalsalary').tail(4)) #Insert # Update # emp.loc[emp['totalsalary']==10000]=15000 # emp.loc[emp['totalsalary']==15000,'totalsalary']=25000 # print(emp) #Delete #emp=emp.drop(emp[emp.totalsalary==10000].index) print(emp) #print(emp.head(6)) #print(emp.tail(6))...
Pandas DataFrame groupby() Method - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 # Advance Data Analysis #Group by method import pandas as pd product=[('Limca',20,'Sanchi'),('Frooti',25,'Amul'),('Milk',20,'BK'),('Water',20,'BK'), ('Limca',25,'AK'),('Frooti',20,'SK'),('Milk',28,'BK'),('Water',30,'Sanchi'), ('Limca',27,'Sanchi'),('Frooti',29,'AK'),('Milk',25,'Amul'),('Water',45,'Sanchi'), ('Water',29,'Amul'),('Limca',40,'DK'),('Frooti',32,'Amul'),('Water',40,'Sanchi') ] #print(product) df=pd.DataFrame(product,columns=['Product Name','Price','Distributor']) df1=df.groupby('Product Name')...
Pandas DataFrame where() Method - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 Pandas Dataset 1 Pandas Dataset 2 Pandas Dataset 3 import pandas as pd df=pd.read_excel("D://mypandas/studentinfo.xlsx") print(df) df.set_index('Name',inplace=True) print(df) print("------------------------------------------") df1=df.where(lambda x:x<80,'A+') print(df1)...
Pandas DataFrame aggregate() Method - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 # Advance Data Analysis #Aggrigate Functions # max(),min(),avg(),count(),sum(),mod(),mean() import pandas as pd product=[('Limca',20,'Sanchi'),('Frooti',25,'Amul'),('Milk',10,'BK'),('Water',20,'BK'), ('Limca',25,'AK'),('Frooti',20,'SK'),('Milk',28,'BK'),('Water',30,'Sanchi'), ('Limca',27,'Sanchi'),('Frooti',29,'AK'),('Milk',25,'Amul'),('Water',45,'Sanchi'), ('Water',29,'Amul'),('Limca',40,'DK'),('Frooti',12,'Amul'),('Water',40,'Sanchi') ] #print(product) df=pd.DataFrame(product,columns=['Product Name','Price','Distributor']) #print(df)...
Difference Between loc() and iloc() in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 Pandas Dataset # loc and iloc methods import pandas as pd myfile="D://mypandas/employee1.xlsx" df=pd.read_excel(myfile) print(df.loc[5,'empname']) # m=int(input("Enter starting index value: ")) #...
Concat Function in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 # Advance Data Analysis #Concat DataFrame import pandas as pd df1=pd.DataFrame({'empname':['Rahul','Vijay','Dipesh'],'Age':[45,43,54]}) df2=pd.DataFrame({'dept':['CSE','IT','HR'],'Salary in lakhs ':[23,33,28]}) df3=pd.DataFrame({'HRA':[5000,6000,4000],'TA':[3000,4000,3400]}) print("EmpName Age Dept Salary HRA...
How to Apply Joins in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 # Advance Data Analysis #Join in DataFrame import pandas as pd df1=pd.DataFrame({'empname':['rahul','vijay','dipesh'],'Age':[45,43,54]}) df2=pd.DataFrame({'empname':['rahul','vijay','amit'],'Salary in lakhs ':[23,33,28]}) print(df1) print("----------------------------------------") print(df2) print("-------------------------------------------") #...
Sorting in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 Pandas Dataset # Sorting import pandas as pd myfile="D://mypandas/employee.xlsx" df=pd.read_excel(myfile) #print(df) #print(df.sort_index(ascending=True)) #print(df.sort_values(['empname'],ascending=False)) #print(df.columns) #print(df.sort_values('totalsalary')) Program 2 # Duplicate import pandas...
Slicing Pandas Dataframe - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 Pandas Dataset #Slicing in DataFrame import pandas as pd myfile="D://mypandas/employee.xlsx" df=pd.read_excel(myfile) #df[start:stop:step] #print(df[['empname','totalsalary']]) #print(df[1:11:2]) #print(df[['empname','totalsalary']][1:11:2]) #print(df.head(3)) #print(df.tail(4)) # print(df.columns) # print(df[['empname','totalsalary']])...
Properties of Dataframe in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 # Property of DataFrame # index , columns ,size, ndim,shape,value, memory_usage(),empty import pandas as pd data=[(1,'vivek',8000),(2,'vikas',38000),(3,'rahul',78000),(4,'rajesh',55000)] df=pd.DataFrame(data) print(df) print(df.empty) print(df.memory_usage()) #...
How to Apply Filter in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 Pandas Dataset # Filter in Python import pandas as pd myfile="D://mypandas/employee2.xlsx" df=pd.read_excel(myfile) #print(df.loc[(df['totalsalary']>10000)]) # and & or | not ~ #print(df.loc[(df['gender']=='male')...
Handling Missing Data in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 Pandas Dataset 1 Pandas Dataset 2 # Missing Values import pandas as pd myfile="D://mypandas/employee1.xlsx" df=pd.read_excel(myfile) print(df[['empname','TA']].dropna()) # print("Before") # print(df) #...
Methods of Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 #add,sub,multiply,div,mod,max,min,prod,cumprod,sum,cumsum ,mean import pandas as pd mylist=[15,52,10,42,5] sr1=pd.Series(mylist) sr1. print(sr1.median()) #print(sr1.cummax()) # print(sr1.cummin()) # print(sr1.cumsum()) # 1 3 6 10 15...
Properties of Series in Pandas - DataFlair
Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!! Program 1 # Properities of Series # index,name,size values,empty,ndim, memory_usage() # nbytes ,shape ,array ,dtype import pandas as pd mylist=[10,20,33,40,53,60,79,80,93,100] mysr=pd.Series(mylist,dtype=int) print(type(mysr)) myar=mysr.array...
C Project - Number Guessing Game - DataFlair
Get Certified in C Programming and Take Your Skills to the Next Level Program 1 // Project for Guess randmom number #include<stdio.h> #include<conio.h> #include<time.h> #define clrscr() system("cls") int main() { clrscr(); int me,you,i=1,count=10; srand(time(NULL));...
C Practical - Simple Calculator and Temperature Converter - DataFlair
Get Certified in C Programming and Take Your Skills to the Next Level Program 1 // Simple calculator #include<stdio.h> #include<conio.h> #define clrscr() system("cls") int main() { char operator1; double num1,num2,num3; clrscr(); printf("Enter First Number:...
How to Create Your Own Command in C - DataFlair
Get Certified in C Programming and Take Your Skills to the Next Level Program 1 #include<stdio.h> #include<conio.h> int main(int argc,char *argv[]) { if(argc==2) { FILE *fp=NULL; fp=fopen(argv[1],"r"); if(fp==NULL) printf("File not found"); else { char...
C Project - How to Generate Random Number - DataFlair
Get Certified in C Programming and Take Your Skills to the Next Level Program 1 #include<stdio.h> #include<conio.h> #include<time.h> #define clrscr() system("cls") int main() { clrscr(); int n,l,u; // srand(time(NULL)); printf("Enter value of Lower Bound:...
C Command Line Arguments - DataFlair
Get Certified in C Programming and Take Your Skills to the Next Level Program 1 #include<stdio.h> #include<conio.h> #include<string.h> int main(int argc,char *argv[]) { // printf("nTotal Arguements: %d",argc); // printf("n1 Arguement: %s",argv[0]); // printf("n2 Arguement:...
C Project - Coin Toss Game - DataFlair
Get Certified in C Programming and Take Your Skills to the Next Level Program 1 #include<stdio.h> #include<conio.h> #include<time.h> #define clrscr() system("cls") int main() { clrscr(); int userchoice,coinchoice; srand(time(0)); printf("n Welcome in the coin toss...
C Program to Find Largest and Smallest Element in an Array - DataFlair
Get Certified in C Programming and Take Your Skills to the Next Level Program 1 //Largest element from array #include<stdio.h> #include<conio.h> int main() { system("cls"); int ar[500],n,i,max,pos; printf("n Enter the limit:"); scanf("%d",&n); printf("Enter elements...
C Do While Loop - DataFlair
Get Certified in C Programming and Take Your Skills to the Next Level Program 1 #include<stdio.h> #include<conio.h> int main() { int choice; system("cls"); do { printf("n------------------Menu-----------------------"); printf("n 1.Factorialn 2.Reverse n 3. Power n 4.Exit");...