从dataframe字符串列中提取日/年并求和[Python]

import pandas as pd
from datetime import datetime

df = pd.DataFrame({'date_column': ['2022-01-01', '2022-02-15', '2022-03-20']})

df['date_column'] = pd.to_datetime(df['date_column'])

df['day'] = df['date_column'].dt.day
df['year'] = df['date_column'].dt.year

sum_of_days = df['day'].sum()
sum_of_years = df['year'].sum()

import pandas as pd
from datetime import datetime

df = pd.DataFrame({'date_column': ['2022-01-01', '2022-02-15', '2022-03-20']})

df['date_column'] = pd.to_datetime(df['date_column'])

df['day'] = df['date_column'].dt.day
df['year'] = df['date_column'].dt.year

sum_of_days = df['day'].sum()
sum_of_years = df['year'].sum()

print("Sum of days:", sum_of_days)
print("Sum of years:", sum_of_years)