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
   452   453   454   455   456   457   458   459   460   461   462