Page 457 - AI Ver 3.0 class 10_Flipbook
P. 457
• Creating a DataFrame with column index
[1]: import numpy as np
import pandas as pd
a1 = np.array([10,20,30])
a2 = np.array([11,22,33])
f2=pd.DataFrame([a1,a2],columns=['R1' ,'R2' , 'R3' ])
print(f2)
R1 R2 R3
0 10 20 30
1 11 22 33
• Creating a DataFrame using a Python List
[1]: import pandas as pd
cities = ['Delhi', 'Mumbai', 'Chennai', 'Kolkata' ]
f1 = pd.DataFrame(cities)
print(f1)
0
0 Delhi
1 Mumbai
2 Chennai
3 Kolkata
• Creating a DataFrame using a Python dictionary
[1]: import pandas as pd
d1={'Name': ['Riya','Sonali','Sneha' ],'Marks': [92,90,89]}
f2=pd.DataFrame(d1,index=[11,22,33])
print(f2)
Name Marks
11 Riya 92
22 Sonali 90
33 Sneha 89
Basic Operations in a DataFrame
Some of the basic operations of DataFrame are as follows:
• Adding a new row
[1]: f2.loc[44]=['Nitin',84]
print(f2)
Name Marks
11 Riya 92
22 Sonali 90
33 Sneha 89
44 Nitin 84
• Adding a new column
[1]: f2['Section' ]=['A' , 'E' , 'E' , 'C' ]
print(f2)
Name Marks Section
11 Riya 92 A
22 Sonali 90 E
33 Sneha 89 E
44 Nitin 84 C
Advance Python (Practical) 455

