Panda: read csv datetime - Revision history

Onnowpurbo at 03:10, 8 August 2019

2019-08-08T03:10:19Z

Onnowpurbo at 03:01, 8 August 2019

2019-08-08T03:01:20Z

Onnowpurbo at 02:03, 7 August 2019

2019-08-07T02:03:00Z

Onnowpurbo at 02:01, 7 August 2019

2019-08-07T02:01:31Z

Onnowpurbo at 01:40, 7 August 2019

2019-08-07T01:40:26Z

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)

@@ Line 1: / Line 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)
- 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)

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

@@ Line 7: / Line 7: @@
   print(x)
   x.info()
 ==Cara 2==

@@ Line 5: / Line 5: @@
   x = pandas.read_csv('/home/onno/TensorFlow/TEMP-train.csv', parse_dates=True, index_col='DateTime',
                                   names=['DateTime', 'X'], header=None, sep=',')
+  print(x)
 ==Cara 2==

← 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