英文:
Convert date in pandas series
问题
我需要帮助：pandas数据集中有一个日期列。其中一个列中的日期格式为"September 25, 2021"。我无法将其转换为"yyyy-mm-dd"格式（2021-09-25）。这对于将来将这些数据导入到mysql中是必要的（我通过dbever进行工作）。也许这是一个愚蠢的问题，但我是新手。
尝试使用to_datetime函数，但出现了这种错误（IndexError: list index out of range）：
date = {'January': '01', 'February': '02', 'March': '03', 'April': '04', 'May': '05', 'June': '06','July': '07', 'August': '08', 'September': '09', 'October': '10', 'November': '11', 'December': '12'}new_date = []for d in df['date_added']:month = d.split(' ')[0]day = d.split(' ')[1]year = d.split(', ')[2]res = year.split('-') + date[month].split('-') + daynew_date.append(res)
英文:
I need help: pandas dataset has a date column. The date in one of the columns is in the format "September 25, 2021 ". I can't convert this to "yyyy-mm-dd" format (2021-09-25). This is necessary in order to import this data into mysql in the future (I work through dbever).
Might be a stupid question but I'm a newbie
Tried to use to_datetime function and this way (IndexError: list index out of range):
date = {'January': '01', 'February': '02', 'March': '03', 'April': '04', 'May': '05', 'June': '06','July': '07', 'August': '08', 'September': '09', 'October': '10', 'November': '11', 'December': '12'}new_date = []for d in df['date_added']:month = d.split(' ')[0]day = d.split(' ')[1]year = d.split(', ')[2]res = year.split('-') + date[month].split('-') + daynew_date.append(res)
答案1
得分: 0
你可以使用strftime。以下是一个示例：
date_string = "September 25, 2021"date = pd.to_datetime(date_string)formatted_date = date.strftime('%Y-%m-%d')print(formatted_date) #2021-09-25
英文:
I think you can use strftime. Here is an example:
date_string = "September 25, 2021"date = pd.to_datetime(date_string)formatted_date = date.strftime('%Y-%m-%d')print(formatted_date) #2021-09-25
答案2
得分: 0
import pandas as pddf = pd.DataFrame({'date_added': ['September 25, 2010', 'April 1, 2023']})print(df)print()# 如果你实际上需要 datetime 对象df.date_added = pd.to_datetime(df.date_added) # dtype = datetime64[ns]print(df)print()# 重置数据框df = pd.DataFrame({'date_added': ['September 25, 2010', 'April 1, 2023']})# 如果你需要一个格式化的字符串df.date_added = pd.to_datetime(df.date_added).dt.strftime('%Y-%m-%d') # dtype = objectprint(df)
英文:
import pandas as pddf = pd.DataFrame({'date_added': ['September 25, 2010', 'April 1, 2023']})print(df)print()# If you need actually need datetime objectdf.date_added = pd.to_datetime(df.date_added) # dtype = datetime64[ns]print(df)print()# reset dataframedf = pd.DataFrame({'date_added': ['September 25, 2010', 'April 1, 2023']})# If you need a formatted stringdf.date_added = pd.to_datetime(df.date_added).dt.strftime('%Y-%m-%d') # dtype = objectprint(df)
Output:
date_added0 September 25, 20101 April 1, 2023date_added0 2010-09-251 2023-04-01date_added0 2010-09-251 2023-04-01
答案3
得分: 0
import pandas as pddf = pd.DataFrame({'date_added': ['September 25, 2010', 'April 1, 2023']})r = pd.to_datetime(df['date_added'], format='%B %d, %Y')print(r)
Result
0 2010-09-251 2023-04-01Name: date_added, dtype: datetime64[ns]
英文:
import pandas as pddf = pd.DataFrame({'date_added': ['September 25, 2010', 'April 1, 2023']})r = pd.to_datetime(df['date_added'], format='%B %d, %Y')print(r)
Result
0 2010-09-251 2023-04-01Name: date_added, dtype: datetime64[ns]
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论