3b Operation on DataFrames

Import pandas as pd

data = [['axel',32], ['alice', 26], ['alex', 45]]

df = pd.DataFrame(data,columns=['name','age'])

print(df)

c = pd.DataFrame([1,2,3], columns=['example'])

df['example'] = c['example']

print(df)

print(df)

del df['example']

print(df)

print(df.loc[0])

print(df.loc[2])

print(df.iloc[0])

user = pd.DataFrame([['vivian',33]], columns= ['name','age'])

df = df.append(user)

print(df)

# delete row

df = df.drop(0)

print(df)