Python Data Wrangling and Manipulation with Pandas

August 17, 2023, 2:00pm to 5:00pm

To receive a Zoom link after registering above, please fill out the affiliations form if you have not done so at least once before: https://dlab.berkeley.edu/affiliations

Trying to register, but not affiliated with the UCB campus? If you are from Berkeley Lab (LBL), UCSF, CZ Biohub, or other organizations, please register via our partner portals here.

Location: Remote via Zoom. Link will be sent on the morning of the event.

Recordings: This D-Lab workshop will be recorded and made available to UC Berkeley participants for a limited time. Your registration for the event indicates your consent to having any images, comments and chat messages included as part of the video recording materials that are made available.

Date & Time: This workshop runs from 2pm-5pm on:

• Thursday, August 17

Start Time: D-Lab workshops start 10 minutes after the scheduled start time (“Berkeley Time”). We will admit all participants from the waiting room at that time.

Description

Pandas is a Python package that provides fast, flexible, and expressive data structures designed to make working with 'relational' or 'labeled' data both easy and intuitive. It enables doing practical, real world data analysis in Python. In this workshop, we'll work with example data and go through the various steps you might need to prepare data for analysis.

We will cover: 

  • Pandas data structures

  • Loading data

  • Subsetting and filtering

  • Calculating summary statistics

  • Dealing with missing values

  • Merging data sets

  • Creating new variables

  • Basic plotting

  • Exporting data

Prerequisites: D-Lab’s Python Fundamentals introductory series or equivalent knowledge.

GitHub Repository: https://github.com/dlab-berkeley/Python-Data-Wrangling

Software Requirements:Installation Instructions for Python Anaconda

Is Python not working on your laptop?

Attend the workshop anyway, we can provide you with a cloud-based solution until you figure out the problems with your local installation.

Feedback: After completing the workshop, please provide us feedback using this form

Questions? Email: dlab-frontdesk@berkeley.edu