Panda: read csv datetime - Revision history

Onnowpurbo at 03:10, 8 August 2019

2019-08-08T03:10:19Z

← Older revision		Revision as of 03:10, 8 August 2019
Line 1:		Line 1:
	==Cara 1==		==Cara 1==

	~~import pandas as pd~~		headers = ['col1', 'col2', 'col3', 'col4']
	~~from datetime import datetime~~		dtypes = {'col1': 'str', 'col2': 'str', 'col3': 'str', 'col4': 'float'}
	headers = ['col1', 'col2', 'col3', 'col4']		parse_dates = ['col1', 'col2']
	dtypes = ~~[datetime~~, ~~datetime~~, str, float]		pd.read_csv(file, sep='\t', header=None, names=headers, dtype=dtypes, parse_dates=parse_dates)
	pd.read_csv(file, sep='\t', header=None, names=headers, dtype=dtypes)

	~~import pandas as pd~~
	~~from datetime import datetime~~		headers = ['Time', 'Value']
	headers = ['Time', 'Value']		dtypes = {'Time': 'str', 'Value': 'float'}
	dtypes = ~~[datetime~~, float]		parse_dates = ['Time']
	pd.read_csv(file, sep=',', header=None, names=headers, dtype=dtypes)		pd.read_csv(file, sep='\t', header=None, names=headers, dtype=dtypes, parse_dates=parse_dates)

Onnowpurbo at 03:01, 8 August 2019

2019-08-08T03:01:20Z

@@ Line 1: / Line 1: @@
 ==Cara 1==
@@ Line 11: / Line 26: @@
 ==Cara 2==
   import numpy as np

Onnowpurbo at 02:03, 7 August 2019

2019-08-07T02:03:00Z

← Older revision		Revision as of 02:03, 7 August 2019
Line 7:		Line 7:
	print(x)		print(x)
	x.info()		x.info()
			print(x.head())


	==Cara 2==		==Cara 2==

Onnowpurbo at 02:01, 7 August 2019

2019-08-07T02:01:31Z

← Older revision		Revision as of 02:01, 7 August 2019
Line 5:		Line 5:
	x = pandas.read_csv('/home/onno/TensorFlow/TEMP-train.csv', parse_dates=True, index_col='DateTime',		x = pandas.read_csv('/home/onno/TensorFlow/TEMP-train.csv', parse_dates=True, index_col='DateTime',
	names=['DateTime', 'X'], header=None, sep=',')		names=['DateTime', 'X'], header=None, sep=',')
	x		print(x)
			x.info()

	==Cara 2==		==Cara 2==

Onnowpurbo at 01:40, 7 August 2019

2019-08-07T01:40:26Z

← Older revision		Revision as of 01:40, 7 August 2019
Line 1:		Line 1:
			==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=',')
			x

			==Cara 2==

	import numpy as np		import numpy as np

Onnowpurbo: Created page with " 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..."

2019-08-07T01:35:13Z

Created page with " 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..."

New page

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)