メインコンテンツへスキップ

ホーム Python

コース

Pythonでの金融データのインポートと管理

中級スキルレベル

更新日 2023/02

このコースでは、Pythonで多様なツールやデータ源を用いて金融データを取り込み、管理する方法を学びます。

コースを無料で開始

PythonApplied Finance

5時間

16 ビデオ

53 演習

4,350 XP

45,036

修了証明書

何千もの企業の従業員が支持

チームのトレーニングを担当していますか？

Businessをお試しください

コース説明

「Python for Data Science」で身につけたスキルを実際の金融データに活用したい方に向けて、このコースは非常に役立つツールをご紹介します。まず、Excelからpandasへ、そしてpandasからExcelへデータをやり取りする方法を学びます。次に、GoogleやYahoo! FinanceといったオンラインAPIから株価データを取得し、連邦準備制度理事会（Federal Reserve）のマクロデータやOANDAの為替レートを取得する方法を学びます。最後に、さまざまな期間のリターンの計算、IPOのセクター別パフォーマンス分析、相関の計算と要約を行います。

前提条件

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!

チャプターを開始

Pythonでの金融データのインポートと管理

コース完了

修了証明書を取得

この修了書をLinkedInや履歴書、CVに追加しましょう
ソーシャルメディアや人事評価で共有しましょう今すぐ登録

19百万人を超える学習者と共にPythonでの金融データのインポートと管理を始めましょう！

DataCamp for Mobileでデータスキルを磨きましょう

モバイルコースと毎日の 5 分間のコーディングチャレンジで、外出先でも進歩できます。