import pandas as pd
import numpy as np
a=[92812191,189291281,9218291,1298182]
b=['a','ab','abc','abcd']
c=[1,12,123,1234]
d=[9,98,987,9876]
e=[9,np.NaN,98,987,9876]
print(pd.Series(a,[1,2,3,5]))
smarks={'name':['rain','drake','larry'],'grade':['A1','A2','B1']}
df1=pd.DataFrame(smarks)
print(df1)
import pandas as pd
df1=pd.DataFrame({'first':[10,20,30,40],'second':[4,24,7,9],'third':[30,40,50,70]})
df2=pd.DataFrame({'first':[17,18,19,20],'second':[14,15,17,19],'third':[13,14,15,17]})
print(df1)
print(df2)
df3=df1.rsub(df2)
print(df3)
df1=df1.reindex([1,2,3,4],copy=False)
print(df1)
import pandas as pd
import numpy as np
df1=pd.DataFrame({'name':['a','ab','abc','abcd',np.NaN],'roll':[1,12,123,np.NaN,1234],'admno.':[9,np.NaN,98,987,9876],'class':[np.NaN,'IX','X','XI','XII'],'section':['A','B','C',np.NaN,'D']})
df1.insert(1,'poc',[np.NaN,np.NaN,np.NaN,np.NaN,np.NaN])
print(df1)
df1=df1.fillna('o')
print(df1)
df1=df1.ffill(axis=0)
df1.bfill()
print(df1)
import pandas as pd
'''1'''
d1=pd.Series(['Neil','Zain','roths','beatle','Selene'],[1827,8219,1982,219821,4912])
for x in (d1.index):
if x>5000:
print(x)
'''2'''
#a=input("enter name:")
#s1=pd.Series([x for x in a])
#print(s1)
'''3'''
ki=pd.Series([12,33,33,4,4,31,11])
print(sum(ki))
print(sum(ki)/(ki.size))
'''4'''
df1=pd.DataFrame({'name':['a','ab','abc','abcd'],'roll':[1,12,123,1234],'admno.':[9,98,987,9876],'class':['IX','X','XI','XII'],'section':['A','B','C','D']})
print(df1)
df1.insert(5,'phone',[92812191,189291281,9218291,1298182])
print(df1)
print(df1.loc[2:4,'name':'phone'])
print(df1.iloc[2:4,0:5])