课程

Importing and Managing Financial Data in Python

中级技能水平

更新时间 2023年2月

In this course, you'll learn how to import and manage financial data in Python using various tools and sources.

免费开始课程

PythonApplied Finance

5小时

16 视频

53 道练习

4,350 XP

45,036

成就证明

深受数千家公司学习者的喜爱

需要团队培训？

企业版试用

课程描述

If you want to apply your new 'Python for Data Science' skills to real-world financial data, then this course will give you some very valuable tools. First, you will learn how to get data out of Excel into pandas and back. Then, you will learn how to pull stock prices from various online APIs like Google or Yahoo! Finance, macro data from the Federal Reserve, and exchange rates from OANDA. Finally, you will learn how to calculate returns for various time horizons, analyze stock performance by sector for IPOs, and calculate and summarize correlations.

先决条件

Data Manipulation with pandas

1

Importing stock listing data from Excel

In this chapter, you will learn how to import, clean and combine data from Excel workbook sheets into a pandas DataFrame. You will also practice grouping data, summarizing information for categories, and visualizing the result using subplots and heatmaps. You will use data on companies listed on the stock exchanges NASDAQ, NYSE, and AMEX with information on company name, stock symbol, last market capitalization and price, sector or industry group, and IPO year. In Chapter 2, you will build on this data to download and analyze stock price history for some of these companies.

Reading, inspecting, and cleaning data from CSV

Import stock listing info from the NASDAQ

How to fix the data import?

Read data using .read_csv() with adequate parsing arguments

Read data from Excel worksheets

Load listing info from a single sheet

Load listing data from two sheets

Combine data from multiple worksheets

Load all listing data and iterate over key-value dictionary pairs

How many companies are listed on the NYSE and NASDAQ?

Automate the loading and combining of data from multiple Excel worksheets

2

Importing financial data from the web

This chapter introduces online data access to Google Finance and the Federal Reserve Data Service through the pandas DataReader. You will pull data, perform basic manipulations, combine data series, and visualize the results.

The DataReader: Access financial data online

Get stock data for a single company

Visualize a stock price trend

Economic data from the Federal Reserve

Visualize the long-term oil price trend

Compare labor market participation and unemployment rates

Compare bond and stock performance

Select stocks and get data from Yahoo! Finance

Select the top 5 listed consumer companies

Get the ticker of the largest consumer services company

Get the largest consumer company listed after 1998

Get several stocks & manage a MultiIndex

Get data for the 3 largest financial companies

3

Summarizing your data and visualizing the result

In this chapter, you will learn how to capture key characteristics of individual variables in simple metrics. As a result, it will be easier to understand the distribution of the variables in your data set: Which values are central to, or typical of your data? Is your data widely dispersed, or rather narrowly distributed around some mid point? Are there outliers? What does the overall distribution look like?

Summarize your data with descriptive stats

List the poorest and richest countries worldwide

Global incomes: Central tendency

Describe the distribution of your data with quantiles

Global incomes: Dispersion

Deciles of the global income distribution

Getting all the statistics

Visualize the distribution of your data

Visualizing international income distribution

Growth rates in Brazil, China, and the US

Highlighting values in the distribution

Summarize categorical variables

Companies by sector on all exchanges

Technology IPOs by year on all exchanges

4

Aggregating and describing your data by category

This chapter introduces the ability to group data by one or more categorical variables, and to calculate and visualize summary statistics for each caategory. In the process, you will learn to compare company statistics for different sectors and IPO vintages, analyze the global income distribution over time, and learn how to create various statistical charts from the seaborn library.

Aggregate your data by category

Median market capitalization by sector

Median market capitalization by IPO year

All summary statistics by sector

More ways to aggregate your data

Company value by exchange and sector

Calculate several metrics by sector and exchange

Summary statistics by category with seaborn

Plot IPO timeline for all exchanges using countplot()

Global median per capita income over time

Calculate several metrics by sector and IPO year

Distributions by category with seaborn

Inflation trends in China, India, and the US

Distribution of inflation rates in China, India, and the US

Congratulations!

Importing and Managing Financial Data in Python

课程完成

获得成就证明

将此证书添加到您的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Importing and Managing Financial Data in Python！

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。