Jun-15-2021, 01:01 PM
Hello,
I.m not an expert with pandas, however:
I.m not an expert with pandas, however:
- data is already a dataframe.
- drop lines 10 - 13 and all will be fine.
import pandas as pd import numpy as np from datetime import datetime, timedelta # read data, date_parser=[0]: first column to datetime, data = pd.read_csv('minimal_data.csv', delimiter = ';', date_parser=[0], usecols=[0, 1], header = 0, names = ["MyColumn1","MyColumn2"]), print(data)
Output:( MyColumn1 MyColumn2
0 09.06.2021 14:35:05 100
1 09.06.2021 14:36:16 100
2 09.06.2021 14:37:26 100
3 09.06.2021 14:38:37 100
4 09.06.2021 14:39:48 100
5 09.06.2021 14:40:59 100
6 09.06.2021 14:42:10 100
7 09.06.2021 14:43:21 100
8 09.06.2021 14:44:32 100,)