Join Dataframes / CSV



In [1]:

    
import pandas as pd



In [14]:

    
pd.merge(b, c)









    Out[14]:






  
    
      
      Sample ID
      Purcell Factor
    
  
  
    
      0
      T14
      NaN
    
    
      1
      T20
      NaN



In [24]:

    
a = pd.read_csv('./Screening.CSV')
a = a.set_index('Sample ID')

b = pd.read_csv('./fp.csv')
b = b.set_index('Sample ID')

c = pd.read_csv('./fp_nWG.csv')
c = c.set_index('Sample ID')

out = pd.concat([a, b, c], axis=1)
out = out.sort_values('RunOrder')

out.to_csv('T-series.csv')

Analysis



In [37]:

    
# Select onlly chips with no Yb
out = out[out['Yb'] == -1]
out = out.drop('Reflection (%)', 1)
out = out.drop('Transmission (%)', 1)
out = out.sort_values('RunOrder')



In [38]:

    
out.to_csv('Er-only.csv')



In [ ]: