Advertisement
Guest User

Untitled

a guest
May 29th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. import pandas as pd
  2. import os
  3.  
  4. file = os.path.abspath('C:\\Zerodha\\Pi\\Exported\\Nifty 50.csv')
  5. df = pd.read_csv(file)
  6. df['Date'] = pd.to_datetime(df['Date'], format = '%d/%m/%y %I:%M:%S %p')
  7. df['Time'] = df['Date'].apply(lambda x: x.strftime('%H:%M'))
  8. df['Date'] = df['Date'].apply(lambda x: x.strftime('%y-%m-%d'))
  9. df.set_index('Date', drop=True, inplace=True)
  10. df.columns = ['O', 'H', 'L', 'C', 'V', 'Time']
  11. df.to_csv('Nifty 50.csv')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement