V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
推荐学习书目
› Learn Python the Hard Way
Python Sites
› PyPI - Python Package Index
› http://diveintopython.org/toc/index.html
› Pocoo
值得关注的项目
› PyPy
› Celery
› Jinja2
› Read the Docs
› gevent
› pyenv
› virtualenv
› Stackless Python
› Beautiful Soup
› 结巴中文分词
› Green Unicorn
› Sentry
› Shovel
› Pyflakes
› pytest
Python 编程
› pep8 Checker
Styles
› PEP 8
› Google Python Style Guide
› Code Style from The Hitchhiker's Guide
This topic created in 1175 days ago, the information mentioned may be changed or developed.
日期 两年收益率 五年收益率 十年收益率
1 2023-01-30 2.435 2.723 2.913
2 2023-01-31 2.419 2.703 2.897
...........
变成下面：
[ {year: '2023-01-30', value: 2.435, category: '两年'}，
{year: '2023-01-31', value: 2.419, category: '两年'}
]
1 2023-01-30 2.435 2.723 2.913
2 2023-01-31 2.419 2.703 2.897
...........
变成下面：
[ {year: '2023-01-30', value: 2.435, category: '两年'}，
{year: '2023-01-31', value: 2.419, category: '两年'}
]
6 replies • 2023-02-06 16:11:46 +08:00
 |
1
Etuloser Feb 6, 2023  1
逐行读取当作字符串，split 切空格
定义一个 dict ，遍历写入切完的值 |
 |
2
particlec OP 好，我试一下
|
 |
3
sky857412 Feb 6, 2023 2
好像是 pandas 的数据格式，如果能用 pandas 读取就可以用 pandas 的方法转换了
|
|
4
particlec OP 是 pandas 格式但是我不会用 pandas 转
|
|
6
particlec OP 试了遍历和.to_json(orient="records", force_ascii=False)都可以，谢谢大佬们
|
Select Language