Python Pandas - 从数据帧创建多索引
要从DataFrame创建Multiindex,请使用MultiIndex。from_frame()方法。首先,让我们创建一个列表字典-
d = {'Car': ['BMW', 'Lexus', 'Audi', 'Mercedes', 'Jaguar', 'Bentley'],'Date_of_purchase': ['2020-10-10', '2020-10-12', '2020-10-17', '2020-10-16', '2020-10-19', '2020-10-22'] }接下来,从上面的列表字典创建一个PandasDataFrame-
dataFrame = pd.DataFrame(d)
现在创建多索引使用from_frame()-
print(pd.MultiIndex.from_frame(dataFrame))
示例
以下是代码-
import pandas as pd
#dictionaryoflists
d = {'Car': ['BMW', 'Lexus', 'Audi', 'Mercedes', 'Jaguar', 'Bentley'],'Date_of_purchase': ['2020-10-10', '2020-10-12', '2020-10-17', '2020-10-16', '2020-10-19', '2020-10-22']}
#creatingdataframefromtheabovedictionaryoflists
dataFrame = pd.DataFrame(d)
print("DataFrame...\n",dataFrame)
#creatingmultipleindexes
print(pd.MultiIndex.from_frame(dataFrame))输出结果这将产生以下输出-
DataFrame...
Car Date_of_purchase
0 BMW 2020-10-10
1 Lexus 2020-10-12
2 Audi 2020-10-17
3 Mercedes 2020-10-16
4 Jaguar 2020-10-19
5 Bentley 2020-10-22
MultiIndex ([( 'BMW','2020-10-10'),
( 'Lexus','2020-10-12'),
( 'Audi','2020-10-17'),
('Mercedes','2020-10-16'),
( 'Jaguar','2020-10-19'),
( 'Bentley '2020-10-22')],
names=['Car,Date _of_purchase'])热门推荐
10 小红书平安祝福语简短
11 生日祝福语大全女孩简短
12 收生日红包祝福语 简短
13 领证幽默祝福语简短
14 法考面试祝福语简短
15 老哥出门祝福语简短语
16 送灯祝福语简短独特
17 幼儿狗年祝福语大全简短
18 好听的元旦简短祝福语