Reading a csv file

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Thread Modes

Reading a csv file

buran

Posts: 8,089

Threads: 154

Joined: Sep 2016

Reputation: 582

Feb-26-2021, 05:48 AM (This post was last modified: Feb-26-2021, 05:48 AM by buran.)

Try to pass sep=; to pd.read_csv()
Also you will need to skip the first line or maybe first two and maybe specify the column names.
Ideally provide sample file

If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Find

Messages In This Thread

Reading a csv file - by Led_Zeppelin - Feb-25-2021, 10:03 PM

RE: Reading a csv file - by eddywinch82 - Feb-25-2021, 11:38 PM

RE: Reading a csv file - by buran - Feb-26-2021, 05:48 AM

Possibly Related Threads…
Thread		Author	Replies	Views	Last Post
	problems with reading csv file.	MassiJames	3	619	Nov-16-2023, 03:41 PM Last Post: snippsat
	Reading a file name fron a folder on my desktop	Fiona	4	900	Aug-23-2023, 11:11 AM Last Post: Axel_Erfurt
	Reading data from excel file –> process it >>then write to another excel output file	Jennifer_Jone	0	1,091	Mar-14-2023, 07:59 PM Last Post: Jennifer_Jone
	Reading a file	JonWayn	3	1,093	Dec-30-2022, 10:18 AM Last Post: ibreeden
	Reading Specific Rows In a CSV File	finndude	3	981	Dec-13-2022, 03:19 PM Last Post: finndude
	Excel file reading problem	max70990	1	891	Dec-11-2022, 07:00 PM Last Post: deanhystad
	Replace columns indexes reading a XSLX file	Larry1888	2	978	Nov-18-2022, 10:16 PM Last Post: Pedroski55
	Failing reading a file and cannot exit it...	tester_V	8	1,801	Aug-19-2022, 10:27 PM Last Post: tester_V
	Reading .csv file	doug2019	4	1,700	Apr-29-2022, 09:55 PM Last Post: deanhystad
	Reading an Input File	DaveG	1	1,247	Mar-27-2022, 02:08 AM Last Post: deanhystad

Users browsing this thread: 2 Guest(s)

View a Printable Version

Reading a csv file

User Panel Messages

Announcements