Home

This workshop is an introduction to data wrangling in Julia with a focus on data I/O and DataFramesMeta.jl. We will cover the following topics:

Reading and writing data:
- CSV files
- Excel (.xlsx) files
- SAS (.sasb7dat and .xpt)
Select:
- Selecting specific columns and rows using @select and @subset macros
Transform:
- Applying transformations to one or more columns using the @transform macro
Grouping and combining:
- Grouping data using the groupby function
- Combining groups and summarizing data using the @combine and @by macros
Chaining:
- Perform all data wrangling operations in a single block using the @chain macro

Prerequisites

We recommend users being familiar with Julia syntax, especially variables and types.

The formal requirements are the Julia Syntax Workshop and its pre-requisites.

Schedule

Time (HH:MM)	Activity	Description
00:00	Setup	Download files required for the workshop
00:25	Reading and writing data	Showcase `01-files.jl`
00:40	Select	Showcase `02-select_subset.jl`
00:50	Transform	Showcase `03-transform.jl`
01:00	Grouping and combining	Showcase `04-grouping.jl`
01:05	Chaining	Showcase `05-chaining.jl`
01:15	Closing remarks	See if there are any questions and feedback

If you have any suggestions or want to get in touch with our education team, please send an email to training@pumas.ai.