/python-for-excel-users-webinar

Primary LanguageJupyter Notebook

DataCamp icon



Python for Excel Users live training

Welcome to this live, hands-on training where you will learn how to upgrade from being an Excel user to using Python.

In most organizations across all industries, data fluency, technical skills and a data-driven mindset are becoming sought after skills that drive organizational success in the digital age. This shift has spurred on the adoption of tools that go beyond Excel, which allow for more robust data analysis, visualization and presentation. In this notebook, you will learn:

  • How to import Excel files into pandas.
  • Filter, add new columns, and explore DataFrames.
  • Apply common Excel operations such as pivot tables and VLOOKUP in Python.
  • Present data as visualizations using matplotlib and seaborn.

The dataset to be used in this webinar is an Excel file named sales_data_dirty.xlsx - it contains 4 sheets, each containing the following columns:


alt