frame = pd.read_clipboard(header=None)
frame.head(5)# 输出前五条数据0123456...262728293031320 Algeria 1292.01-21.80 NaN NaN 723.4136.17...13.51876.49-26.29245.20-4.90651.66-32.581 Angola 93.207.46688.2568.83670.0147.53...41.41398.18-19.91366.340.00878.1961.472 Benin 1282.2988.482412.1148.40739.48-7.39...30.482432.26-81.39657.94-38.64830.33-8.303 Botswana 660.120.00953.8695.39874.6678.72...-23.70 NaN NaN 1154.90-24.69 NaN NaN
4 Burkina Faso 1101.3630.66 NaN NaN 745.22-29.81...-63.30 NaN NaN 642.20-18.00 NaN NaN
# 根据数据透视表,创建多层索引
col = pd.MultiIndex.from_arrays([['2017','2017','2017','2017','2017','2017','2017','2017','2018','2018','2018','2018','2018','2018','2018','2018&