pandas
Series Object : one dimensional
import pandas as pd
data = [ [10,20,30],[40,50,60]]
series = pd.Series(data)
print("\n")
print(series)
print("\n")
# we can also use
series1 = pd.Series([[10,20,30],[40,50,60]])
print(series1)
import pandas as pd
a = pd.Series([10,20,30,40],index=["a","b","c","d"])
print (a)
import pandas as pd
b = pd.Series([50,60,70,80],index = "a b c d".split(" "))
print (b)
Data Frame : 2d dimension
import pandas as pd
b = pd.DataFrame({"Name" : "apple banana mango watermelon".split(" "),"Price" : [100,200,290,800]})
print (b)
Changing index name :
import pandas as pd
a=pd.DataFrame({"Name" : "apple banana mango watermelon".split(" "),"Price" : [100,200,290,800]})
a.rename(index ={0: "a",1:"b",2:"c ",3:"d "} , inplace = True)
print (a)
Concatenation :
pd.concat([var, var1],axis=1)
pd.merge(var,var1,on=" ", how = " ")
df = pd.DataFrame({"name": "vishal kanchan sangita prdip abhi".split(" "),"marks_math":[80,60,70,80,80]})
print(df)
print("\n")
df1 = pd.DataFrame({"name": "vishal kanchan sangita prdip dhiraj".split(" "),"marks_sci":[80,60,70,80,67]})
print(df1)
# concatenation
print("\n")
print(pd.concat([df, df1]))#bydefault axis0
print("\n")
print(pd.concat([df, df1],axis= 1))
Merge :
print(pd.merge(df,df1,on= "name",how= "inner")) ....( On= same keys in df, df1)
print("\n")
print(pd.merge(df,df1,on="name",how="outer"))
print(pd.merge(df,df1,on= "name",how= "left")) .....also add indicator= True
print("\n")
print(pd.merge(df,df1,on="name",how="right"))
print(pd.merge(df,df1,on= "name",how= "outer",indicator=True))
Comments
Post a Comment
If you have any doubts, please let me know