Difference between revisions of "Panda: read csv datetime"
Jump to navigation
Jump to search
Onnowpurbo (talk | contribs) |
Onnowpurbo (talk | contribs) |
||
Line 7: | Line 7: | ||
print(x) | print(x) | ||
x.info() | x.info() | ||
+ | print(x.head()) | ||
+ | |||
==Cara 2== | ==Cara 2== |
Revision as of 09:03, 7 August 2019
Cara 1
import pandas x = pandas.read_csv('/home/onno/TensorFlow/TEMP-train.csv', parse_dates=True, index_col='DateTime', names=['DateTime', 'X'], header=None, sep=',') print(x) x.info() print(x.head())
Cara 2
import numpy as np import matplotlib.pyplot as plt import pandas as pd infile = '/home/onno/TensorFlow/TEMP-train.csv' mydateparser = lambda x: pd.datetime.strptime(x, "%Y-%m-%d %H:%M:%S") df = pd.read_csv(infile, sep=',', names=['datetime', 'value'], parse_dates=['datetime'], date_parser=mydateparser)