본문으로 바로가기

강의

Python으로 금융 데이터 가져오기와 관리

중급기술 수준

업데이트됨 2023. 2.

이 코스에서는 다양한 도구와 소스를 활용해 Python에서 금융 데이터를 불러오고 관리하는 방법을 학습합니다.

무료로 강의 시작

PythonApplied Finance

5시간

16 동영상

53 연습 문제

4,350 XP

45,016

성취 증명서

수천 개 기업의 학습자들이 사랑하는

팀을 교육하시나요?

비즈니스용으로 체험해 보세요

강의 설명

새로 익힌 'Python for Data Science' 역량을 실제 금융 데이터에 활용하고 싶다면, 이 과정이 매우 유용한 도구를 제공해 드립니다. 먼저 Excel에서 pandas로 데이터를 가져오고 다시 내보내는 방법을 배웁니다. 이어서 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분 코딩 챌린지를 통해 이동 중에도 학습 효과를 높이세요.