Changing date column of csv with Python Pandas

Question

I have a csv file like this:

Tarih, Şimdi, Açılış, Yüksek, Düşük, Hac., Fark %
31.05.2022, 8,28, 8,25, 8,38, 8,23, 108,84M, 0,61%

(more than a thousand lines)

I want to change it like this:

Tarih, Şimdi, Açılış, Yüksek, Düşük, Hac., Fark %
5/31/2022, 8.28, 8.25, 8.38, 8.23, 108.84M, 0.61%

Especially "Date" format is Day.Month.Year and I need to put it in Month/Day/Year format.

i write the code like this:

import pandas as pd
import numpy as np
import datetime

data=pd.read_csv("qwe.csv", encoding= 'utf-8')

df.Tarih=df.Tarih.str.replace(".","/")
df.Şimdi=df.Şimdi.str.replace(",",".")
df.Açılış=df.Açılış.str.replace(",",".")
df.Yüksek=df.Yüksek.str.replace(",",".")
df.Düşük=df.Düşük.str.replace(",",".")

for i in df['Tarih']:
    q = 1
    datetime_obj = datetime.datetime.strptime(i, "%d/%m/%Y")
    df['Tarih'].loc[df['Tarih'].values == q] = datetime_obj

But the "for" loop in my code doesn't work. I need help on this. Thank you

It's going to be hard to import a CSV that uses comma as a decimal separator - I'd address that separately - see Convert commas decimal separators to dots within a Dataframe. The date issue is relatively straightforward. — Steve
– Steve, Commented Jun 1, 2022 at 8:30
Also perhaps you could elaborate on "doesn't work" - see How to Ask — Steve
– Steve, Commented Jun 1, 2022 at 8:32
I changed the separators. The problem is changing the date format :) ps: df.Tarih=df.Tarih.str.replace(".","/") is wrong — Oguz Han
– Oguz Han, Commented Jun 1, 2022 at 8:40

Steve · Accepted Answer · 2022-06-01 09:02:40Z

2

Just looking at converting the date, you can import to a datetime object with arguments for pd.read_csv, then convert to your desired format by applying strftime to each entry.

If I have the following tmp.csv:

date, value
30.05.2022, 4.2
31.05.2022, 42
01.06.2022, 420

import pandas as pd
df = pd.read_csv('tmp.csv', parse_dates=['date'], dayfirst=True)
df['date'] = df['date'].dt.strftime('%m/%d/%Y')
print(df)

output:

         date   value
0  05/30/2022     4.2
1  05/31/2022    42.0
2  06/01/2022   420.0

edited Jun 1, 2022 at 9:02

answered Jun 1, 2022 at 8:53

Steve

1,60712 silver badges23 bronze badges

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

2 Comments

Steve Over a year ago

There are other ways of changing the representation of the date - see the range of answers on How to change the datetime format in Pandas

Oguz Han Over a year ago

Thank you for the examples. My problem is solved

Collectives™ on Stack Overflow

Changing date column of csv with Python Pandas

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related