Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. In[2]: df1.std()
  2. Out[2]:
  3. some_int 15281.99
  4. some_float 5.302293
  5.  
  6. In[3]: df2.std()
  7. Out[3]:
  8. some_int 15281.99
  9. some_float 6.691013
  10.  
  11. import pandas as pd
  12. import numpy as np
  13.  
  14. data_list = list()
  15. csv_files = ['a.csv', 'b.csv', 'c.csv']
  16.  
  17. for csv_file in csv_files:
  18.  
  19. # load csv_file
  20. tmp_df = pd.read_csv(str(tmp_file), index_col='ID', dtype=np.float64)
  21.  
  22. # replace infs by na
  23. tmp_df.replace([np.inf, -np.inf], np.nan, inplace=True)
  24.  
  25. # manipulate tmp_df
  26. tmp_df = tmp_df*2
  27.  
  28. data_list.append(tmp_df)
  29.  
  30. df = pd.concat(data_list, ignore_index=True)
  31. df.reset_index(inplace=True)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement