【pandas的多层索引】

最新推荐文章于 2024-01-11 22:12:27 发布

菜鸟小超

最新推荐文章于 2024-01-11 22:12:27 发布

阅读量197

点赞数

文章标签： pandas python 开发语言

本文链接：https://blog.csdn.net/weixin_41777118/article/details/131753275

版权

# import pandas as pd

# # 创建列多层索引
# columns = pd.MultiIndex.from_tuples([('X', 'A'), ('X', 'B'), ('Y', 'C'), ('Y', 'D')])

# # 创建带有多层索引的DataFrame
# df = pd.DataFrame(data=[[1, 2, 3, 4]], columns=columns)
# print(df)


import pandas as pd

# 创建时间索引
time_index = pd.date_range('2023-01-01', periods=3, freq='D')
print(time_index)
# 创建多层索引
index = pd.MultiIndex.from_product([time_index, ['A', 'B']], names=['Time', 'Series'])
print(index)
# # 创建带有多层索引的DataFrame
df = pd.DataFrame(data=[[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12],[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12]], index=index, columns=pd.MultiIndex.from_product([['X', 'D'], ['Feature1', 'Feature2']]))
print(df)

DatetimeIndex(['2023-01-01', '2023-01-02', '2023-01-03'], dtype='datetime64[ns]', freq='D')
MultiIndex([('2023-01-01', 'A'),
            ('2023-01-01', 'B'),
            ('2023-01-02', 'A'),
            ('2023-01-02', 'B'),
            ('2023-01-03', 'A'),
            ('2023-01-03', 'B')],
           names=['Time', 'Series'])
PS C:\Users\chao\Desktop\DailyStudy> & C:/Users/chao/AppData/Local/Programs/Python/Python38/python.exe c:/Users/chao/Desktop/DailyStudy/day1.py
DatetimeIndex(['2023-01-01', '2023-01-02', '2023-01-03'], dtype='datetime64[ns]', freq='D')
MultiIndex([('2023-01-01', 'A'),
            ('2023-01-01', 'B'),
            ('2023-01-02', 'A'),
            ('2023-01-02', 'B'),
            ('2023-01-03', 'A'),
            ('2023-01-03', 'B')],
           names=['Time', 'Series'])
                         X                 D
                  Feature1 Feature2 Feature1 Feature2
Time       Series
2023-01-01 A             1        2        3        4
           B             5        6        7        8
2023-01-02 A             9       10       11       12
           B             1        2        3        4
2023-01-03 A             5        6        7        8
           B             9       10       11       12