Importing a .csv file to dataframe

crispyduck · (This post was last modified: Jan-09-2019, 04:28 PM by ichabod801.)

Hello Bunny Rabbit

here are the first 6 lines of the .csv

Output:Reading values	Reading values timestamp	Insert time	Reporting type	Errorcode	OBIS code	Unit	Factor	CT factor	Quality	Quality Status Word	Reading reason
Reading values,"Reading values timestamp","Insert time","Reporting type","Errorcode","OBIS code","Unit","Factor","CT factor","Quality","Quality Status Word","Reading reason"											
29041.601,"21.11.2018 14:15:00","21.11.2018 14:28:12","absolute","0","8-0:1.0.0*255","mÂ³","1.000","1.000","Real value","No errors","Periodic"											
29041.601,"21.11.2018 14:30:00","21.11.2018 14:45:06","absolute","0","8-0:1.0.0*255","mÂ³","1.000","1.000","Real value","No errors","Periodic"											
29041.601,"21.11.2018 14:45:00","21.11.2018 14:59:26","absolute","0","8-0:1.0.0*255","mÂ³","1.000","1.000","Real value","No errors","Periodic"											
29041.601,"21.11.2018 15:00:00","21.11.2018 15:15:57","absolute","0","8-0:1.0.0*255","mÂ³","1.000","1.000","Real value","No errors","Periodic"

here is the output

Output:                                         Reading values  \
0     Reading values,"Reading values timestamp","Ins...   
1     29041.601,"21.11.2018 14:15:00","21.11.2018 14...   
2     29041.601,"21.11.2018 14:30:00","21.11.2018 14...   
3     29041.601,"21.11.2018 14:45:00","21.11.2018 14...   
4     29041.601,"21.11.2018 15:00:00","21.11.2018 15...   
5     29041.601,"21.11.2018 15:30:00","21.11.2018 15...   
6     29041.601,"21.11.2018 16:15:00","21.11.2018 16...   
7     29041.601,"21.11.2018 16:30:00","21.11.2018 16...   
8     29041.601,"21.11.2018 17:15:00","21.11.2018 17...   
9     29041.601,"21.11.2018 18:15:00","21.11.2018 18...   
10    29041.601,"21.11.2018 19:30:00","21.11.2018 19...   
11    29041.601,"21.11.2018 20:15:00","21.11.2018 20...   
12    29041.601,"21.11.2018 21:00:00","21.11.2018 21...   
13    29041.601,"21.11.2018 22:15:00","21.11.2018 22...   
14    29041.601,"21.11.2018 22:30:00","21.11.2018 22...   
15    29041.601,"21.11.2018 23:00:00","21.11.2018 23...   
16    29041.601,"21.11.2018 23:15:00","21.11.2018 23...   
17    29041.601,"21.11.2018 23:45:00","22.11.2018 00...   
18    29041.601,"22.11.2018 00:00:00","22.11.2018 00...   
19    29041.601,"22.11.2018 00:30:00","22.11.2018 00...   
20    29041.601,"22.11.2018 01:30:00","22.11.2018 01...

hope this helps

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	docx file to pandas dataframe/excel	iitip92	1	3,198	Jun-27-2024, 05:28 AM Last Post: Pedroski55
	Converting a json file to a dataframe with rows and columns	eyavuz21	13	15,395	Jan-29-2023, 03:59 PM Last Post: eyavuz21
	New2Python: Help with Importing/Mapping Image Src to Image Code in File	CluelessITguy	0	1,296	Nov-17-2022, 04:46 PM Last Post: CluelessITguy
	Problem with importing Python file in Visual Studio Code	DXav	7	10,730	Jun-15-2022, 12:54 PM Last Post: snippsat
	importing functions from a separate python file in a separate directory	Scordomaniac	3	2,468	May-17-2022, 07:49 AM Last Post: Pedroski55
	Extract parts of a log-file and put it in a dataframe	hasiro	4	10,848	Apr-08-2022, 01:18 PM Last Post: hasiro
	Importing a function from another file runs the old lines also	dedesssse	6	4,013	Jul-06-2021, 07:04 PM Last Post: deanhystad
	Importing text file into excel spreadsheet with formatting	david_dsmn	1	4,875	Apr-05-2021, 10:21 PM Last Post: david_dsmn
	Json File more pages #pandas #dataframe	nio74maz	0	2,335	Dec-30-2020, 05:32 AM Last Post: nio74maz
	importing a CSV file into Python	russoj5	1	4,273	Aug-02-2020, 12:03 AM Last Post: scidam

Importing a .csv file to dataframe

User Panel Messages

Announcements