subtracting part of a column in a data frame

Question

I have a date column in a dataframe but its type is string :

palma.Created_at[1:5]

- 1    2019-10-20 12:08:40 +0200
- 2    2019-10-20 12:08:40 +0200
- 3    2019-10-20 12:08:40 +0200
- 4    2019-10-20 12:08:40 +0200
- 5    2019-10-20 12:08:40 +0200
- Name: Created_at, dtype: object

and I want to be just like : 2019-10-20. So how to convert it like this and should I convert it to date type or no?

can you post the raw output of `palma.Created_at[1:5]` without bullet points? — ignoring_gravity, Dec 28 '19 at 10:47
Does this answer your question? [Keep only date part when using pandas.to\_datetime](https://stackoverflow.com/questions/16176996/keep-only-date-part-when-using-pandas-to-datetime) — Riccardo Bucco, Dec 28 '19 at 10:58

ignoring_gravity · Answer 1 · 2019-12-28T10:58:52.500

0

You could do

import pandas as pd

palma.Created_at = pd.to_datetime(palma.Created_at).dt.date

edited Dec 28 '19 at 10:58

answered Dec 28 '19 at 10:48

ignoring_gravity

6,677
4
32
65

dt is the column name that i want to change right ? – Mohy Mohamed Dec 28 '19 at 10:50
and hwo do i subtract only the year-month-day from it ? – Mohy Mohamed Dec 28 '19 at 10:50
@MohyMohamed sorry, I missed the column name - have edited my answer. You still need `dt` to access the datetime part – ignoring_gravity Dec 28 '19 at 10:51
"hwo do i subtract only the year-month-day from it " I don't understand, can you give an example? – ignoring_gravity Dec 28 '19 at 10:52
i want the column become instead of `2019-10-20 12:08:40 +0200` to be `2019-10-20` – Mohy Mohamed Dec 28 '19 at 10:55
OK, I think what I've written should do that, can you try? – ignoring_gravity Dec 28 '19 at 10:59

subtracting part of a column in a data frame

1 Answers1