DataFrame in Python Class - 3

 

1.

#Create an Empty DataFrame

import pandas as pd

df=pd.DataFrame()

print(df)

Output:

Empty DataFrame

Columns: []

Index: []

2.

#Create a DataFrame using list

import pandas as pd

D=[10,15,20,25,35]

df=pd.DataFrame(D)

print(df)

Output:

    0

0  10

1  15

2  20

3  25

4  35

3.

#Create a DataFrame using list of multiple columns

import pandas as pd

D=[["Udai",17],["Aditya",15],["Aakash",16],["Deepak",18]]

df=pd.DataFrame(D)

print(df)

Output:

        0   1

0    Udai  17

1  Aditya  15

2  Aakash  16

3  Deepak  18

4.

#Create a DataFrame using list using labels

import pandas as pd

D=[["Udai",17],["Aditya",15],["Aakash",16],["Deepak",18]]

C=["Name","Age"]

I=[1,2,3,4]

df=pd.DataFrame(D,I,columns=C)

df.index.name="Roll No."

print(df)

Output:

            Name  Age

Roll No.             

1           Udai   17

2         Aditya   15

3         Aakash   16

4         Deepak   18

5.

#Create a DataFrame using Series

import pandas as pd

D1=pd.Series({'udai':65,'aditya':60,'aakash':70,'deepak':50})

D2=pd.Series({'udai':28,'aditya':30,'aakash':20,'deepak':10})

df=pd.DataFrame({"Marks":D1,"practical":D2})

print(df)

OR

import pandas as pd

D1={'udai':65,'aditya':60,'aakash':70,'deepak':50}

D2={'udai':28,'aditya':30,'aakash':20,'deepak':10}

S1=pd.Series(D1)

S2=pd.Series(D2)

df=pd.DataFrame({"Marks":S1,"practical":S2})

print(df)

Output:

        Marks  practical

udai       65         28

aditya     60         30

aakash     70         20

deepak     50         10

6.

#Create a DataFrame using Dictionary

import pandas as pd

I=['IP','Bio','Chemistry','Physics','English']

D={"2018":[50,60,70,80.5,90],"2019":[40,35,45,55,32], \

   "2020":[65,75,85,45,52],}

df=pd.DataFrame(D,I)

print(df)

Output:

           2018  2019  2020

IP         50.0    40    65

Bio        60.0    35    75

Chemistry  70.0    45    85

Physics    80.5    55    45

English    90.0    32    52