November 2022
Intermediate to advanced
392 pages
10h 8m
Chinese
Content preview from Python算法交易
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
处理金融数据
｜
67
3.1.4
导出到
Excel
和
JSON
当需要以非
Python
特定格式共享数据时，
pandas
也擅长导出存储在
DataFrame
对
象中的数据。除了能够导出为
CSV
文件之外，
pandas
还允许人们以
Excel
电子表格
文件和
JSON
文件的形式进行导出，这两种文件在金融行业中都是流行的数据交换
格式。这样的导出过程通常只需要一个方法调用：
In [16]: data.to_excel('data/aapl.xls', 'AAPL')
In [17]: data.to_json('data/aapl.json')
In [18]: ls -n data/
total 24
-rw-r--r-- 1 501 20 3067 Aug 25 11:47 aapl.json
-rw-r--r-- 1 501 20 5632 Aug 25 11:47 aapl.xls
导出数据到磁盘上的
Excel
文件。
导出数据到磁盘上的
JSON
文件。
特别是在与
Excel
电子表格文件进行交互时，除了导出数据，还有更优雅的做法。
例如，
xlwings
，它是一个功能强大的
Python
软件包，允许在
Python
和
Excel
之间
进行高效且智能的交互（请访问
xlwings
主页（
http://xlwings.org
））
3.1.5
从
Excel
和
JSON
读取数据
现在，也可以使用
Excel
电子表格文件和
JSON
数据文件的形式提供数据，
pandas
也可以从这些文件中读取数据。该方法与用 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.