Pandas data frame read_CSV: why automatically make first column data as index

Question

I'm looking at sensor data with Pandas dataframes. The text file I have does not have an index field.

It starts with time data, but when I use this code to load data from a file into a Pandas data frame,

dfSensordata = pd.read_csv(fileFolder + filename + ext, header=1, sep=',', index_col=False)

the first column, which was time data, changes to index data.

In brief, I expeced dfSensordata to be like this:

Time	1A [V]
time1	data 1
time2	data 1

but result was like this:

Index	Time	1A [V]
time1	data 1
time2	data 1

I also tried these codes, but they didn't change anything.

pd.read_csv(column_index =0)
pd.read_csv(column_index =None)
pd.read_csv(column_index =False)

Could you help me figure out what to do?

Add a sample of the csv as text, not a screenshot of it

Bera
– Bera

2024-05-28 07:32:16 +00:00
Commented May 28, 2024 at 7:32 — Bera
– Bera, Commented May 28, 2024 at 7:32

Borja_042 · Accepted Answer · 2024-05-28 07:59:42Z

0

Your problem maybe is on the first comma displayed on the csv (87,). Try to delete it from the file and reading it setting index=False. YOur are using comma as a separator for the file and it might be confussed about the first comma.

answered May 28, 2024 at 7:59

Borja_042

1,0711 gold badge16 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Borja_042 Over a year ago

@Bokyung Seo Was the issue solved? I would appreciate you to accept and upvote the answer

Collectives™ on Stack Overflow

Pandas data frame read_CSV: why automatically make first column data as index

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related