notebook.community

Edit and run



In [1]:

    
import numpy as np
import pandas as pd
from pandas import DataFrame, Series



In [6]:

    
ser1 = Series([0,1,2], index=['A','B','C'])

ser1









    Out[6]:





A    0
B    1
C    2
dtype: int64



In [9]:

    
ser2 = Series([3,4,5,6], index=['A','B','C', 'D'])

ser2









    Out[9]:





A    3
B    4
C    5
D    6
dtype: int64



In [10]:

    
ser1 + ser2









    Out[10]:





A    3.0
B    5.0
C    7.0
D    NaN
dtype: float64



In [13]:

    
# dataframes
df1 = DataFrame(np.arange(4).reshape((2,2)), columns=list('AB'), index=['SF','LA'])
df1



In [20]:

    
df2 = DataFrame(np.arange(9).reshape((3,3)), columns=list('ADC'), index=['SF','LA', 'NY'])
df2



In [15]:

    
df1 + df2



In [16]:

    
# replacing null values
df1.add(df2, fill_value=0)



In [17]:

    
# operation between series and dataframes



In [18]:

    
ser3 = df2.ix[0]
ser3









    Out[18]:





A    0
D    1
C    2
Name: SF, dtype: int32



In [21]:

    
df2-ser3



In [ ]: