python - 如何从纪元获取周数和年份

Question

我有一些数据如下，需要在同一行中获取周数和年份。

data.head()

+---------------+
|     epoch     |
+---------------+
| 1580495399964 |
| 1580495399334 |
| 1580495397591 |
| 1580495396967 |
| 1580495396331 |
+---------------+

我怎样才能得到这样的结果：

data.head()
+---------------+-----------+
|     epoch     | week-year |
+---------------+-----------+
| 1580495399964 | 4-2020    |
| 1580495399334 | 4-2020    |
| 1580495397591 | 4-2020    |
| 1580495396967 | 4-2020    |
| 1580495396331 | 4-2020    |
+---------------+-----------+

标签： pythondateweek-number

Answer 1

尝试：

data['week-year'] = data.epoch.apply(pd.to_datetime, unit='ms')
data['week-year'] = data['week-year'].dt.strftime('%U-%Y')

           epoch week-year
0  1580495399964    4-2020
1  1580495399334    4-2020
2  1580495397591    4-2020
3  1580495396967    4-2020
4  1580495396331    4-2020