Change specific columns in a csv file into integer with pandas

Question

I have a csv file that contains 6 columns in such format:

2021-04-13 11:03:13+02:00,3.0,3.0,3.0,12.0,12.0

Now I want to remove the decimal point of each column except for the first one.

I already tried using df.style.format aswell as the df.astype(int) and pd.set_option('precision', 0) but in the latter two it always gets stuck on the first column, since that doesn't quiet fit ( ValueError: invalid literal for int() with base 10: '2021-04-13 11:03:13+02:00' )

Any help would be much appreciated!

RavinderSingh13 · Accepted Answer · 2021-04-29 07:59:02Z

1

With your shown samples, please try following. Using iloc functionality of pandas.

df.iloc[:,1:] = df.iloc[:,1:].astype(int)

df will be as follows after running above code:

0,2021-04-13 11:03:13+02:00,3,3,3,12,12

answered Apr 29, 2021 at 7:59

RavinderSingh13

135k14 gold badges61 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

Change specific columns in a csv file into integer with pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related