Session

David Sol

David Sol

Site Reliability Engineer

Wizeline

Let's forget about Excel: Conda + Jupyter + Pandas to leave office behind

Excel? Where we’re going, we don’t need Excel. You can leave Office and the Spreadsheet behind. You can use Python, Conda, Jupiter, and Pandas to quickly load, analyze and export your data in a better way. No more memory limits, strange functions, and manual processes. Let’s go to the future.

This is a 3 hour workshop to give a Python beginner a walk into Pandas. We'll learn:

  • How to install Conda for Python, Pandas, and all of its Data processing ecosystem.
  • How to use Jupyter Lab and Jupiter Notebooks.
  • How to use Pandas for data analysis.

About Pandas, including:

  • Import and Export data.
  • Analyze and clean data.
  • Filtering.
  • Data Processing.
  • Simple plotting.

About Jupyter, including:

  • Simple Markdown.
  • Sharing Notebooks.
  • Exporting as HTML or PDF.