Guest User

Untitled

a guest
Jul 19th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. import pandas as pd
  2.  
  3.  
  4.  
  5. files = [',Nikkei225.csv', ',TOPIX.csv', ',6501.csv']
  6.  
  7. df_all = pd.DataFrame()
  8.  
  9. for f in files:
  10. df = pd.read_csv(f)
  11. df = df.set_index('Date')
  12. df.columns = pd.MultiIndex.from_tuples([(f, c) for c in df.columns])
  13. df_all = pd.concat([df_all, df], axis=1, sort=True)
  14.  
  15.  
  16. print(df_all.dropna())
Add Comment
Please, Sign In to add comment