程序问答   发布时间:2022-06-02  发布网站:大佬教程  code.js-code.com
大佬教程收集整理的这篇文章主要介绍了尝试将逗号分隔的文本放入熊猫数据框中大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。

如何解决尝试将逗号分隔的文本放入熊猫数据框中?

开发过程中遇到尝试将逗号分隔的文本放入熊猫数据框中的问题如何解决?下面主要结合日常开发的经验,给出你关于尝试将逗号分隔的文本放入熊猫数据框中的解决方法建议,希望对你解决尝试将逗号分隔的文本放入熊猫数据框中有所启发或帮助;

我无法将 csv 格式的 API 响应放入 Pandas 数据帧。基本的熊猫功能对我不起作用,但我没有那么先进。这是我的 API 调用:

response = requests.get('https://data.messari.io/API/v1/assets/ada/metrics/price/time-serIEs?interval=1d&format=csv')
res = response.text
print(res)


我的结果如下:

timestamp,open,high,low,close,volume
2020-11-01T00:00:00Z,0.09286327819615646,0.09871727981858057,0.09202731479794192,0.09826071504858695,27953080.64663609
2020-11-02T00:00:00Z,0.09819001417519348,0.1003317811814748,0.09112084926053894,0.09226895555284524,41254254.75458492
2020-11-03T00:00:00Z,0.09234523461385429,0.09413545735889374,0.08773058304394568,0.09363476651518426,37144774.90253366
2020-11-04T00:00:00Z,0.09368190716929714,0.09633801612889291,0.09160839185728606,0.09555423612606477,48246578.290414825
2020-11-05T00:00:00Z,0.09559192052364425,0.09828817929479862,0.09088002118247013,0.09753833458793106,58030769.3704354
2020-11-06T00:00:00Z,0.09750162516589665,0.11083340645426493,0.09683186844528095,0.10914401884646008,93252158.61233637
2020-11-07T00:00:00Z,0.10924755625197062,0.11388205911133911,0.08966284049139546,0.10143836960554167,107305104.76963407
2020-11-08T00:00:00Z,0.10148894133039574,0.10844692744217106,0.09985655829775107,0.10663983278639419,48849754.244560465
2020-11-09T00:00:00Z,0.1065097500307075,0.11107389590719384,0.10129986579115952,0.10563273089345326,59259435.36708425
2020-11-10T00:00:00Z,0.10552883048672461,0.10923829156542778,0.10360318113619912,0.1060109344949761,52691927.84209388
2020-11-11T00:00:00Z,0.10612015902043635,0.10905674598943878,0.10510236488698135,0.10609106228443135,47573057.283371046
2020-11-12T00:00:00Z,0.10614360594393216,0.10681335846078742,0.10232194766438421,0.10465039188165146,42303387.305539705
2020-11-13T00:00:00Z,0.10441369045167594,0.10808572111163872,0.10390724729147677,0.10634723504620915,41347674.19876987
2020-11-14T00:00:00Z,0.10638599542224504,0.10730895582745185,0.10087699987198498,0.10411192508857087,38777070.87670336
2020-11-15T00:00:00Z,0.10410694352784117,0.10528841825095998,0.09801025479710317,0.10052079562125252,33138412.88395842
2020-11-16T00:00:00Z,0.09982875688455334,0.10509347105778652,0.09904974565707925,0.10392818606702424,38092438.596709386
2020-11-17T00:00:00Z,0.10392448191102115,0.11249156065627103,0.10326385477778859,0.11057773640038855,69881770.90806274

有人能帮我把这些数据结构化成一个数据帧吗?谢谢!

解决方法

pandas.read_csv 直接允许你指定一个 url。 试试:

df = pd.read_csv("https://data.messari.io/api/v1/assets/ada/metrics/price/time-series?interval=1d&format=csv")

大佬总结

以上是大佬教程为你收集整理的尝试将逗号分隔的文本放入熊猫数据框中全部内容,希望文章能够帮你解决尝试将逗号分隔的文本放入熊猫数据框中所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。