如何将多索引DataFrame转换为标准索引DF?
import pandas as pd
df1 = pd.DataFrame({'old_code': ['00000001', '00000002', '00000003', '00000004'],
'Desc': ['99999991', '99999992 or 99999922', 'Use 99999993 or 99999933', '99999994']},
)
df1.set_index('old_code', inplace=True)
df2=df1["Desc"].str.extractall(r"(?P<new_code>\d{7,9})")
print(df2.head(10))
我的输出如下所示
old_code match new_code
00000001 0 99999991
00000002 0 99999992
1 99999922
00000003 0 99999993
1 99999933
00000004 0 99999994
我正在试着把它变成这样的格式?
old_code new_code
00000001 99999991
00000002 99999992
00000002 99999922
00000003 99999993
00000002 99999933
00000004 99999994