Python Pandas 长宽表转换

最新推荐文章于 2024-01-17 10:47:39 发布

极客小生

最新推荐文章于 2024-01-17 10:47:39 发布

阅读量572

点赞数

文章标签： python pandas

本文链接：https://blog.csdn.net/shengshengshiwo/article/details/114137821

版权

data = pd.read_csv("SanF_MR.csv")

Date Alameda County Contra Costa County Marin County Napa County San Francisco County San Mateo County Santa Clara County Solano County Sonoma County
0 2020/3/5 -0.0258 0.0142 -0.0160 -0.0463 0.0219 -0.0396 -0.0524 -0.0187 -0.0439
1 2020/3/6 0.0364 0.0766 0.0197 0.0350 0.0219 0.0167 -0.0136 0.0463 0.0232
2 2020/3/7 -0.0413 0.0041 -0.0387 -0.0075 -0.0525 -0.0624 -0.0750 0.0086 -0.0137
3 2020/3/8 -0.1229 -0.0865 -0.1319 -0.0952 -0.1616 -0.1370 -0.1452 -0.0854 -0.1128
4 2020/3/9 -0.0744 -0.0357 -0.0760 -0.0514 -0.0956 -0.0779 -0.0781 -0.0200 -0.0414
… … … … … … … … … … …
113 2020/6/26 -0.2103 -0.1298 -0.1558 -0.0886 -0.2991 -0.2218 -0.2077 -0.0857 -0.0873
114 2020/6/27 -0.2500 -0.1631 -0.1913 -0.0990 -0.3348 -0.2436 -0.2308 -0.1220 -0.1455
115 2020/6/28 -0.2931 -0.2205 -0.2249 -0.1512 -0.3591 -0.2932 -0.2681 -0.1630 -0.1866
116 2020/6/29 -0.2715 -0.2018 -0.2241 -0.1904 -0.3478 -0.2830 -0.2688 -0.1538 -0.1719
117 2020/6/30 -0.2534 -0.1800 -0.1704 -0.1472 -0.3172 -0.2437 -0.2399 -0.1254 -0.1356
118 rows × 10 columns

Python 长宽表转换

data = data.melt(
    id_vars="Date",#要保留的主字段{不变的列}
    var_name="County",#拉长的分类变量{变量的列名}
    value_name="MR" #拉长的度量值名称{列名后面的值的列名}
)

Date County MR
0 2020/3/5 Alameda County -0.0258
1 2020/3/6 Alameda County 0.0364
2 2020/3/7 Alameda County -0.0413
3 2020/3/8 Alameda County -0.1229
4 2020/3/9 Alameda County -0.0744
… … … …
1057 2020/6/26 Sonoma County -0.0873
1058 2020/6/27 Sonoma County -0.1455
1059 2020/6/28 Sonoma County -0.1866
1060 2020/6/29 Sonoma County -0.1719
1061 2020/6/30 Sonoma County -0.1356
1062 rows × 3 columns