Difference between revisions of "Panda: read csv datetime"

From OnnoWiki
Jump to navigation Jump to search
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)