擅长:python、mysql、java
<pre><code>import pandas as pd
data = {
'Province': 'Newfound and Labrador',
'January': 204,
'February': 204,
'March': 195,
'April': 173,
'May': 179,
'June': 197,
'July': 204
}
nfl = pd.DataFrame(data, index=[0])
nfl = nfl.transpose().drop('Province').reset_index()
nfl = nfl.rename({'index': 'Months', 0: 'Employed Canadians'}, axis=1)
nfl['Employed Canadians'] = nfl['Employed Canadians'].astype(float)
nfl['Months'] = pd.to_datetime(nfl['Months'], format='%B')
nfl['Months'] = nfl['Months'].apply(lambda x: x.replace(year=2020))
</code></pre>
<p>这应该行得通</p>
<p>请注意,由于没有为每个日期提供年份或日期,datetime对象默认为1970-01-01,因此我最后使用lambda函数将其更改为2020。您可以轻松地将这些日期时间格式化为仅显示为月份名称,但这会将数据类型更改为字符串</p>