Events

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(link is external) Software Requirements:Installation Instructions(link is external) for Python Anaconda Is Python Not working on your laptop? Attend the workshop anyway, we can provide you with a cloud-based solution(link is external) until you figure out the problems with your local installation. Feedback: After completing the workshop, please provide us feedback using this form Questions? Email: [email protected](link sends e-mail) LOCATION: Remote via Zoom. Link will be sent on the morning of the event.

This is a three-hour introductory workshop that will provide an overview of Excel, with no prior experience assumed. Attendees will learn how to use functions for handling data and making calculations, how to build charts and pivot tables, and more. The workshop includes a lecture-style walkthrough of each concept, combined with challenge problems to apply each concept to a real-world data analysis application. Instructors and TAs will provide support for students using Excel on either Windows or Mac, as well as for students using Google Sheets. Prerequisites: None. Workshop Materials: https://github.com/dlab-berkeley/Excel-Fundamentals(link is external) Software Requirements: Installation Instructions(link is external) Is Excel Not working on your laptop? Attend the workshop anyway, we can provide you with a cloud-based solution(link is external) using Google Sheets. Feedback: After completing the workshop, please provide us feedback using this form Questions? Email: [email protected](link sends e-mail) LOCATION: Remote via Zoom. Link will be sent on the morning of the event.