Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- from pandas import DataFrame
- import datetime
- def convert_timestamp_to_datetime(x) :
- return datetime.datetime.fromtimestamp(x/1000).strftime("%Y-%m-%d %H:%M")
- jsonData = [
- [1574337600000, 100, 200, 300, 400, 500],
- [1574330400000, 110, 210, 220, 230, 330],
- ]
- df = DataFrame(jsonData, columns=['Date', 'Open', 'Close', 'High', 'Low', 'Volume'])
- df['Date'] = df['Date'].apply(convert_timestamp_to_datetime)
- df = df.set_index('Date')
- print(df)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement