Interactive Course

Importing & Managing Financial Data in Python

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

  • 5 hours
  • 16 Videos
  • 53 Exercises
  • 21,115 Participants
  • 4,350 XP

Loved by learners at thousands of top companies:

deloitte-grey.svg
whole-foods-grey.svg
credit-suisse-grey.svg
ikea-grey.svg
forrester-grey.svg
ea-grey.svg

Course Description

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.

  1. 1

    Importing stock listing data from Excel

    Free

    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.

  2. 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?

  3. 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.

  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.

  1. 1

    Importing stock listing data from Excel

    Free

    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.

  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.

  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?

  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.

What do other learners have to say?

Devon

“I've used other sites, but DataCamp's been the one that I've stuck with.”

Devon Edwards Joseph

Lloyd's Banking Group

Louis

“DataCamp is the top resource I recommend for learning data science.”

Louis Maiden

Harvard Business School

Ronbowers

“DataCamp is by far my favorite website to learn from.”

Ronald Bowers

Decision Science Analytics @ USAA

Stefan Jansen
Stefan Jansen

Founder & Lead Data Scientist at Applied Artificial Intelligence

Stefan is Lead Data Scientist at Applied AI where he advises Fortune 500 companies and startups on translating business goals into a data & AI strategy, building data science teams, and developing machine learning solutions. Prior to his current venture, he was a partner and managing director at an international investment firm where he built the predictive analytics and investment research practice. Stefan holds Master degrees from Harvard and Free University Berlin, and a CFA Charter. He is the author for ‘Machine Learning for Algorithmic Trading’ and teaches data science at General Assembly.

See More
Icon Icon Icon professional info