Proper Converting
Fortunately, this issue can be easily fixed. The .to_datetime() method has yearfirst and dayfirst boolean parameters that define whether dates start with the year or day, respectively. By default, both parameters are set to False, which is why the first numbers were considered as months (if possible). Since the dates in our data start with the day, we just need to set the dayfirst parameter to True.
Завдання
Swipe to start coding
- Convert the
'Date'column todatetimetype, considering that the day comes first. - Output the first 5 rows and dtypes of the
dfdataframe.
Рішення
99
1
2
3
4
5
6
7
8
9
10
11
12
# Loading the library
import pandas as pd
# Reading the data
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/72be5dde-f3e6-4c40-8881-e1d97ae31287/shops_data3.csv')
# Change column type
df['Date'] = pd.to_datetime(df['Date'], dayfirst = True)
# Displaying first 5 rows and dtypes of dataframe
print(df.head())
print(df.dtypes)
Все було зрозуміло?
Дякуємо за ваш відгук!
Секція 2. Розділ 5
99
1
2
3
4
5
6
7
8
9
10
11
12
# Loading the library
import pandas as pd
# Reading the data
df = pd.read_csv('https://codefinity-content-media.s3.eu-west-1.amazonaws.com/72be5dde-f3e6-4c40-8881-e1d97ae31287/shops_data3.csv')
# Change column type
df['Date'] = pd.___(df['___'], ___ = ___)
# Displaying first 5 rows and dtypes of dataframe
print(df.___())
print(df.___)
Запитати АІ
Запитайте про що завгодно або спробуйте одне із запропонованих запитань, щоб почати наш чат
