python - XLXS文件的长字典(内部的元组值+不同长度)变量不起作用
问题描述
我正在尝试使用 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
解决方案
使用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]
推荐阅读
- reactjs - ReactJS 响应式布局对第一个网格无响应
- python - AttributeError:“模块”对象没有属性“打开”
- javascript - 更新 json 以显示 json 数组中的对象数,而不是 Node 应用程序中的列表
- vue.js - Vue中的绑定图像源不显示图像
- c++ - 序号 3283 不能位于动态链接库 libmysql.dll 中
- selenium - 从哪里开始 webdriver 使用 xpath 查找元素
- sql - sql distinct join - 按顺序匹配两个表
- node.js - 与自定义 Web 应用程序共享 nextcloud 身份验证
- python - 如何使用 pandas 为列选择设置有效的开始和结束条件
- javascript - 如何使用适用于 S3 的 AWS 开发工具包修复 JavaScript 承诺?