长字典(元组值inside+不同长度)变量转换为XLXS文件不起作用

Question

我正在尝试创建一个带有hot3字典值的XLXS文件。我试过用pd.DataFrame.from_dict，但它不能正常工作。要制作一个有价值的XLXS文件对我来说是相当困难的，即使我阅读了Pandas文档...能帮我个忙吗？

我试着搜索一些答案，但找不到！

import openpyxl
import pandas as pd

wb = openpyxl.Workbook()
sheet = wb.active

sl = sorted_list[0]

hot3 = {('BitcoinBTC',): ('Oct 25, 2021', 'Oct 24, 2021', 'Oct 20, 2021', 'Oct 20, 2021'), ('EthereumETH',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25,2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021'), ('CardanoADA',): ('깃허브가 아닌 다른 저장소 사이트 [확인해 봐야함]',), ('SolanaSOL',): ('Oct 25, 2021', 'Oct 25, 2021',
 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021'), ('XRPXRP',): ('Oct 23, 2021', 'Oct 21, 2021', 'Oct 21, 2021', 'Oct 18, 2021', 'Oct 18, 2021', 'Oct 18, 2021', 'Oct 7, 2021', 'Sep 21, 2021', 'Sep 16, 2021', 'Sep 5, 2021'), ('PolkadotDOT',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021',
'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021'), ('DogecoinDOGE',): ('Aug 20, 2021', 'Aug 21, 2021'), ('USD', 'CoinUSDC'): ('Jun 3, 2021', 'Aug 3, 2018'), ('TerraLUNA',): ('1'), ('ChainlinkLINK',): ('Oct 25, 2021', 'Oct 19, 2021'), ('AvalancheAVAX',): ('Oct 22, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 21, 2021', 'Oct 21, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 19, 2021', 'Oct 19, 2021'), ('Wrapped', 'BitcoinWBTC'): ('May 18, 2021',), ('LitecoinLTC',): ('Jun 10, 2021', 'Jun 11, 2020'), ('Binance', 'USDBUSD'): ('Feb 2, 2021',), ('AlgorandALGO',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 21, 2021'), ('Bitcoin', 'CashBCH'): ('??? [???]',), ('PolygonMATIC',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 21, 2021', 'Oct 21, 2021'), ('StellarXLM',): ('Oct 23, 2021', 'Oct 22, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021'), ('CosmosATOM',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021',
'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 22, 2021'), ('Internet', 'ComputerICP'): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 21, 2021'), ('FantomFTM',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 23, 2021', 'Oct 19, 2021'), ('Ethereum', 'ClassicETC'): ('Oct 19, 2021', 'Oct 11, 2021', 'Sep 29, 2021', 'Aug 10, 2021', 'May 4, 2021', 'Mar 25, 2020', 'Mar 21, 2020', 'Mar8, 2020', 'Jan 29, 2020', 'Jan 23, 2020'), ('TRONTRX',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 19, 2021', 'Oct 18, 2021', 'Oct 15, 2021', 'Oct 14, 2021', 'Oct 14, 2021', 'Oct 12, 2021'), ('THETATHETA',): ('Oct 23, 2021', 'Oct 22, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 11, 2021', 'Oct 4, 2021', 'Sep 8, 2021', 'Aug 13, 2021', 'Aug 9, 2021', 'Aug 9, 2021'), ('Bitcoin', 'BEP2BTCB'):
 ('Oct 25, 2021', 'Oct 24, 2021', 'Oct 20, 2021', 'Oct 20, 2021'), ('HederaHBAR',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021'), ('ElrondEGLD',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021'), ('TezosXTZ',): ('??? [???]',), ('NEAR', 'ProtocolNEAR'): ('Oct 22, 2021', 'Sep 6, 2021'), ('MoneroXMR',): ('Oct 18, 2021', 'Sep 1, 2021'), ('The', 'GraphGRT'): ('Oct 25, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 18, 2021', 'Oct 16, 2021', 'Oct 12, 2021'), ('PancakeSwapCAKE',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 19, 2021', 'Oct 16, 2021', 'Oct 12, 2021', 'Oct 11, 2021', 'Oct 8, 2021', 'Oct 7, 2021'), ('EOSEOS',): ('Oct 25, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 21, 2021',
 'Oct 21, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 18, 2021', 'Oct 15, 2021', 'Oct 13, 2021'), ('FlowFLOW',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021',
 'Oct 25, 2021', 'Oct 23, 2021', 'Oct 23, 2021', 'Oct 22, 2021'), ('AaveAAVE',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 22, 2021', 'Oct 18, 2021', 'Oct 18, 2021', 'Oct 14, 2021',
 'Oct 14, 2021', 'Oct 14, 2021'), ('KlaytnKLAY',): ('Oct 21, 2021', 'Oct 19, 2021'), ('IOTAMIOTA',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021'), ('eCashXEC',): ('Oct 25, 2021', 'Oct 22, 2021', 'Oct 19, 2021', 'Oct 19, 2021', 'Oct 29, 2020'), ('QuantQNT',): ('q'), ('KusamaKSM',): ('Jun 16, 2021', 'Jul 28, 2020', 'May 20, 2020', 'Nov 8, 2019'), ('HarmonyONE',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 23, 2021', 'Oct 23, 2021', 'Oct22, 2021'), ('Bitcoin', 'SVBSV'): ('Oct 21, 2021', 'Oct 21, 2021'), ('NeoNEO',): ('Oct 25, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 18, 2021',
 'Oct 8, 2021', 'Sep 22, 2021'), ('WavesWAVES',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 21, 2021'
), ('THORChainRUNE',): ('Oct 25, 2021', 'Oct 21, 2021', 'Oct 18, 2021', 'Oct 14, 2021', 'Oct 14, 2021', 'Oct 12, 2021', 'Oct 12, 2021', 'Oct 12, 2021', 'Oct 5, 2021', 'Sep 21, 2021'), ('StacksSTX',): ('Oct 25,2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 20, 2021'), ('TerraUSDUST',): ('z'), ('BitTorrentBTT',): ('Oct 1, 2021'
, 'Aug 27, 2021', 'Feb 1, 2021', 'Sep 28, 2020', 'Sep 17, 2020', 'Jun 25, 2020', 'Jun 3, 2020', 'Jun 1, 2020', 'Feb 18, 2020', 'Mar 6, 2019'), ('CeloCELO',): ('Oct 25, 2021', 'Sep 29, 2021'), ('ZcashZEC',): ('Oct 16, 2021', 'Oct 10, 2021'), ('HeliumHNT',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 23, 2021', 'Oct 23, 2021', 'Oct 23, 2021', 'Oct 23, 2021'),
 ('DashDASH',): ('Jun 5, 2021', 'Jun 7, 2021'), ('OMG', 'NetworkOMG'): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 6, 2021', 'Oct 6, 2021', 'Oct 6, 2021', 'Sep 24, 2021', 'Sep 22, 2021', 'Sep 13, 2021'), ('AmpAMP',): ('Sep 17, 2021', 'Dec 22, 2020', 'Dec 4, 2020'), ('CompoundCOMP',): ('Oct 22, 2021', 'Jun 27, 2020'), ('ArweaveAR',): ('Oct 11, 2021', 'Sep 5, 2021'), ('Curve', 'DAO', 'TokenCRV'): ('Feb 22, 2021',), ('DecredDCR',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 23, 2021'), ('HoloHOT',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021'), ('Theta', 'FuelTFUEL'): ('Oct 23, 2021'
, 'Oct 22, 2021', 'Oct 20, 2021', 'Oct 20, 2021', 'Oct 11, 2021', 'Oct 4, 2021', 'Sep 8, 2021', 'Aug 13, 2021', 'Aug 9, 2021', 'Aug 9, 2021'), ('NEMXEM',): ('a'), ('Enjin', 'CoinENJ'): ('Nov 2, 2017',), ('NexoNEXO',): ('Apr 20, 2018',), ('RevainREV',): ('Sep 23, 2020', 'Aug 18, 2020', 'Jun 5, 2020', 'Mar 26, 2020', 'Dec 20, 2019', 'Dec 17, 2019', 'Feb 2, 2018'), ('DecentralandMANA',): ('Oct 25, 2021', 'Oct 25, 2021',
'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 23, 2021', 'Oct 23, 2021', 'Oct 23, 2021', 'Oct 23, 2021'), ('ICONICX',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 16, 2021', 'Oct 14, 2021', 'Oct 14, 2021', 'Oct 12, 2021', 'Oct 8, 2021', 'Oct 8, 2021'), ('SushiSwapSUSHI',): ('Oct 11, 2021',), ('MinaMINA',): ('Oct 18, 2021', 'Sep 23, 2021'), ('QtumQTUM',): ('Jun 17, 2021', 'May 17, 2021'), ('ZilliqaZIL',): ('Oct 25, 2021', 'Sep 6, 2021'), ('TrueUSDTUSD',): ('Oct 25, 2021', 'Oct 21, 2021', 'Oct 12, 2021', 'Oct 6, 2021', 'Oct 5, 2021', 'Sep 30, 2021', 'Sep 15, 2021', 'Sep 2,2021', 'Aug 10, 2021', 'May 20, 2021'), ('yearn.financeYFI',): ('a'), ('XDC', 'NetworkXDC'): ('Apr 1, 2021', 'Aug 17, 2020'), ('CelsiusCEL',): ('Oct 11, 2021', 'Sep 27, 2021', 'Aug 29, 2019', 'Apr 16, 2018', 'Feb 5, 2018'), ('RavencoinRVN',): ('May 21, 2021', 'Dec 7, 2020'), ('Bitcoin', 'GoldBTG'): ('Apr 11, 2021', 'Aug 1, 2020'), ('TelcoinTEL',): ('Oct 7, 2021', 'Oct 4, 2021', 'Sep 24, 2021', 'Sep 22, 2021', 'Aug 23, 2021', 'Aug 20, 2021', 'Aug 13, 2021', 'Jul 26, 2021', 'Jul 22, 2021', 'Jun 17, 2021'), ('RenREN',): ('Oct 25, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 21,2021', 'Oct 21, 2021', 'Oct 19, 2021', 'Oct 18, 2021'), ('renBTCRENBTC',): ('Oct 25, 2021', 'Oct 24, 2021', 'Oct 24, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 21, 2021', 'Oct 21, 2021', 'Oct 21, 2021', 'Oct19, 2021', 'Oct 18, 2021'), ('HorizenZEN',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 24, 2021', 'Oct 22, 2021', 'Oct 20, 2021', 'Oct 18, 2021', 'Oct 16, 2021', 'Oct 15, 2021'), ('SerumSRM',): ('Oct 25, 2021', 'Oct 25, 2021', 'Oct 25, 2021', 'Oct 23, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 22, 2021', 'Oct 18, 2021', 'Oct 14, 2021', 'Oct 15, 2021')}


df_st = pd.DataFrame.from_dict(data=hot3)
df_st = df_st.transpose()
df_st.to_excel('hot2.xlsx')

错误消息

  File ".\test.py", line 83, in <module>
    df_st = pd.DataFrame.from_dict(data=hot3)
  File "C:\Users\SK\Desktop\fast\venv\lib\site-packages\pandas\core\frame.py", line 1593, in from_dict
    return cls(data, index=index, columns=columns, dtype=dtype)
  File "C:\Users\SK\Desktop\fast\venv\lib\site-packages\pandas\core\frame.py", line 614, in __init__
    mgr = dict_to_mgr(data, index, columns, dtype=dtype, copy=copy, typ=manager)
  File "C:\Users\SK\Desktop\fast\venv\lib\site-packages\pandas\core\internals\construction.py", line 464, in dict_to_mgr
    return arrays_to_mgr(
  File "C:\Users\SK\Desktop\fast\venv\lib\site-packages\pandas\core\internals\construction.py", line 119, in arrays_to_mgr
    index = _extract_index(arrays)
  File "C:\Users\SK\Desktop\fast\venv\lib\site-packages\pandas\core\internals\construction.py", line 635, in _extract_index
    raise ValueError("All arrays must be of the same length")
ValueError: All arrays must be of the same length

Answer 1

使用pd.DataFrame.from_dict

df_st = pd.DataFrame.from_dict(hot3, orient='index')
print(df_st)

# Output:
                                            0             1             2             3             4             5             6             7             8             9
(BitcoinBTC,)                    Oct 25, 2021  Oct 24, 2021  Oct 20, 2021  Oct 20, 2021          None          None          None          None          None          None
(EthereumETH,)                   Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021   Oct 25,2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021
(CardanoADA,)    깃허브가 아닌 다른 저장소 사이트 [확인해 봐야함]          None          None          None          None          None          None          None          None          None
(SolanaSOL,)                     Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021
(XRPXRP,)                        Oct 23, 2021  Oct 21, 2021  Oct 21, 2021  Oct 18, 2021  Oct 18, 2021  Oct 18, 2021   Oct 7, 2021  Sep 21, 2021  Sep 16, 2021   Sep 5, 2021
...                                       ...           ...           ...           ...           ...           ...           ...           ...           ...           ...
(TelcoinTEL,)                     Oct 7, 2021   Oct 4, 2021  Sep 24, 2021  Sep 22, 2021  Aug 23, 2021  Aug 20, 2021  Aug 13, 2021  Jul 26, 2021  Jul 22, 2021  Jun 17, 2021
(RenREN,)                        Oct 25, 2021  Oct 24, 2021  Oct 24, 2021  Oct 23, 2021  Oct 22, 2021  Oct 21, 2021   Oct 21,2021  Oct 21, 2021  Oct 19, 2021  Oct 18, 2021
(renBTCRENBTC,)                  Oct 25, 2021  Oct 24, 2021  Oct 24, 2021  Oct 23, 2021  Oct 22, 2021  Oct 21, 2021  Oct 21, 2021  Oct 21, 2021   Oct19, 2021  Oct 18, 2021
(HorizenZEN,)                    Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 24, 2021  Oct 22, 2021  Oct 20, 2021  Oct 18, 2021  Oct 16, 2021  Oct 15, 2021
(SerumSRM,)                      Oct 25, 2021  Oct 25, 2021  Oct 25, 2021  Oct 23, 2021  Oct 22, 2021  Oct 22, 2021  Oct 22, 2021  Oct 18, 2021  Oct 14, 2021  Oct 15, 2021

[81 rows x 10 columns]