Data Manipulation & DataFrames
Query, wrangle, and aggregate structured dataset rows. Translate visual spreadsheets filters to Python Pandas commands.
Interactive Console
DataFrames Queries Builder
Interact with the tabular dataset below. Select a query operation tab, set the parameters, and click **Run Wrangle Query** to filter, group, or transform the dataset.
# Active DataFrame state
df_result = df
df_result = df
Spreadsheet Table View
Distribution Visualization
Trace Step Solver
Tabular Operations Reference
Study equivalent expressions between relational databases (SQL), programming packages (Pandas), and native environments (JavaScript).
DataFrame Anatomy
1. Index and Axes:
DataFrames possess two index dimensions: **Axis 0** represents row coordinates, and **Axis 1** represents column names/coordinates.
2. Series vs. DataFrame:
A **Series** is a single-column 1D array accompanied by indices. A **DataFrame** is a 2D tabular container composed of multiple aligned Series items.
3. GroupBy Splitting-Applying-Combining:
Groupby partitions dataset rows by Category, applies an aggregation function (e.g. sum) to reduce each partition to a single statistic, and combines results back into a summary table.
API Translations
Query Mappings:
| Operation | SQL Query | Pandas Code |
|---|---|---|
| Filter | WHERE x > 2 | df[df['x'] > 2] |
| Sort | ORDER BY x DESC | df.sort_values('x', asc=False) |
| Group By | GROUP BY cat | df.groupby('cat').sum() |
| Mutate | SELECT x * 2 | df['y'] = df['x'] * 2 |
Self Evaluation
DataFrames & Wrangling Quiz
Assess your theoretical grasp of indexes, tabular parameters, and slice filters.
Question 1 of 5
Score: 0/0
Correct Answer!
Focus Vocabulary
- Boolean Masking: Filtering rows by evaluating an array of true/false conditional statements.
- Aggregation: Reducing a group of multiple numeric rows to a single descriptive statistic (sum, mean, count).
- Axes Indexing: Axis 0 references rows; Axis 1 references columns.