“ValueError:DataFrame构造函数调用不正确！”将列表列表转换为datafram时

Question

A=[['1'], ['2'], ['3'], ['4'], ['5'], ['6'], ['7'], ['8'], ['9'], ['10'], ['11'], ['12'], ['13'], ['14'], ['15'], ['16'], ['17'], ['18'], ['19'], ['20'], ['21'], ['22'], ['23'], ['24'], ['25'], ['26'], ['27'], ['29'], ['30'], ['31'], ['32'], ['33'], ['34'], ['35'], ['36']]

B=[['Andaman and Nicobar Islands', ' '], ['Andhra Pradesh'], ['Arunachal Pradesh'], ['Assam'], ['Bihar'], ['Chandigarh', ' '], ['Chhattisgarh'], ['Dadra and Nagar Haveli', ' '], ['Daman and Diu', ' '], ['National Capital Territory of Delhi', ' '], ['Goa'], ['Gujarat'], ['Haryana'], ['Himachal Pradesh'], ['Jammu and Kashmir'], ['Jharkhand'], ['Karnataka'], ['Kerala'], ['Lakshadweep', ' '], ['Madhya Pradesh'], ['Maharashtra'], ['Manipur'], ['Meghalaya'], ['Mizoram'], ['Nagaland'], ['Odisha'], ['Puducherry', ' '], ['Rajasthan'], ['Sikkim'], ['Tamil Nadu'], ['Telangana'], ['Tripura'], ['Uttar Pradesh'], ['Uttarakhand'], ['West Bengal']]

C=[['Port Blair'], ['Hyderabad', ' ', '(', 'de jure', ' to 2024)', '\n', 'Amaravati', ' ', '(', 'de facto', ' from 2017)', '[3]', ' ', '[4]', ' ', '[a]'], ['Itanagar'], ['Dispur'], ['Patna'], ['Chandigarh', '[c]'], ['Naya Raipur', '[d]'], ['Silvassa'], ['Daman'], ['New Delhi'], ['Panaji', '[e]'], ['Gandhinagar'], ['Chandigarh'], ['Shimla', '\n', 'Dharamshala', ' (W/2nd)', '[8]', '\n'], ['Srinagar', '\xa0(Summer)', '\n', 'Jammu', '\xa0(Winter)'], ['Ranchi'], ['Bengaluru'], ['Thiruvananthapuram'], ['Kavaratti'], ['Bhopal'], ['Mumbai', '[g]', '\n', 'Nagpur', '\xa0(W/2nd)', '[h]'], ['Imphal'], ['Shillong'], ['Aizawl'], ['Kohima'], ['Bhubaneswar'], ['Puducherry'], ['Jaipur'], ['Gangtok', '[j]'], ['Chennai', '[k]'], ['Hyderabad', '[l]'], ['Agartala'], ['Lucknow'], ['Dehradun', '[m]'], ['Kolkata']]

我有以上三个列表，我希望它将它们转换为以下格式的pandas数据帧：

^{pr2}$

Answer 1

您可以使用itertools和zip来帮助：

from itertools import chain
import pandas as pd

df = pd.DataFrame({'Numbers': list(chain.from_iterable(A)),
                   'State/UT Capital': [' '.join([i[0], j[0]]) for i, j in zip(B, C)]})

结果：

^{pr2}$