Skip to main content
100%

Gist d55d478bb85bfb424d4ea80f2af06d2a

✓ Published0🌍 Public
Aadiamaan92
Last edited Jan 28, 2019
Created on Jan 28, 2019

This example demonstrates a utility function that renames the columns of a pandas DataFrame. It shows how to apply a custom naming scheme, such as joining multi-level column labels with an underscore, or replacing the column names with an explicit list. The function `setcols` accepts a DataFrame and an optional function or list; when no list is provided, it maps the given function across the existing column index. The code relies on pandas’ `columns` attribute and the `map` method, making it a concise tool for data preprocessing before visualization.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 794352132f6e82f36c2cc959d6e10b17

This example demonstrates a data-cleaning workflow for the Iris dataset, showing how column names are standardized before further analysis. It uses pandas DataFrames with a custom `pipe`-based pipeline that chains operations: first, a `csnap` utility snapshots the initial data head labeled "Before"; then, a `setcols` function applies a lambda to transform column names by lowercasing, removing "(cm)" units, stripping whitespace, and replacing spaces with underscores; finally, a second snapshot shows the cleaned head labeled "After". The code relies on `load_iris()` from scikit-learn and pandas' `pipe` method for functional composition, making the before-and-after effect visible in the console output.

Aadiamaan92
67% match
Loading thumbnail…

Gist 575a4d1a506d4f39d35f

This example presents a collection of Python code snippets for data manipulation with the pandas library, focusing on common DataFrame operations. It demonstrates techniques for filtering rows based on column values, handling missing data, renaming columns, and performing data type conversions. The snippets also cover more advanced operations like pivot tables, merging delimited values, and using `pd.melt` for reshaping data. The code includes functions like `df.column_name.unique()`, `pd.pivot_table`, and `df.assign` to illustrate practical workflows for cleaning and transforming tabular data.

SSav10
66% match
Loading thumbnail…

Useful Pandas Snippets

This example demonstrates a collection of practical data manipulation recipes for the Pandas library in Python. It shows how to perform common DataFrame operations, including filtering rows by values, renaming columns, handling missing data, sorting, grouping, pivoting, and converting data types. The snippets use Pandas APIs such as `pd.unique`, `df.isin`, `df.rename`, `df.groupby`, `pd.pivot_table`, and `df.fillna`, along with NumPy functions like `np.where`. The code also covers text processing with `.str` methods, concatenating columns, and creating DataFrames from dictionaries or Django querysets.

Aabehmiel
60% match
Loading thumbnail…

Transformation of DataFrame

This example demonstrates a straightforward transformation of a pandas DataFrame into a two-column structure, converting the original column headers and first-row values into paired “node” and “value” entries. The code builds a list of tuples via `zip(df.columns.tolist(), df.iloc[0,:].values.tolist())`, then wraps it in a new `pd.DataFrame` with the specified column names. No visualization library or rendering occurs; the output is purely tabular, showing how data can be reshaped for downstream analysis or charting.

VVioletVivirand
59% match
Loading thumbnail…

Gist ed8fd08aa5e827575c410b197825369e

This example demonstrates how to filter the Iris dataset to retain only the sepal-related measurement columns. It defines a custom `cfilter` function that applies a lambda-based condition to either rows or columns, then pipes the dataset through a chain that first normalizes column names—converting them to lowercase, stripping units like "(cm)", and replacing spaces with underscores—before filtering columns. The visualization relies on pandas’ `pipe` method and string methods (`str.lower`, `str.replace`, `str.contains`) to transform and subset the data, showcasing a reusable pattern for column selection based on naming conventions.

Aadiamaan92
59% match
Loading thumbnail…

Reorder pandas column using indexes

This example demonstrates how to reorder the columns of a pandas DataFrame based on a custom index sequence. It first extracts the existing column names into a list, then uses list comprehension to select columns by their numeric positions—specifically indices 3, 2, 1, 4, 6, 4, and 8—creating a new DataFrame with the rearranged order. The code relies on pandas’ column indexing and list slicing to perform the reordering.

KKevinGutowski
57% match
Loading thumbnail…

Gist 740405b6405a6644fd16d3a50588de51

This example shows a step-by-step transformation of the classic wine dataset, progressively filtering and selecting columns to isolate alcohol content, color intensity, and hue before randomly sampling five rows. The code chains pandas operations—including `rename`, `assign`, `query`, and `sort_values`—through a custom `csnap` helper that snapshots the intermediate state after each step. It uses NumPy’s `np.where` to create a binary `color_filter` column based on hue and color intensity thresholds, then resets the index and samples five rows with `sample(5)`. The visualization highlights how pipelined data wrangling can be inspected at each stage.

Aadiamaan92
57% match
Loading thumbnail…

Gist 6ac95622ce9dd73d237ca6b17b2d5543

This visualization demonstrates a method-chaining utility for pandas DataFrames, allowing users to inspect intermediate data states during complex transformations. The `csnap` function takes a DataFrame, an optional transformation function, and a message, displaying the result of applying that function to the data while returning the original DataFrame for continued chaining. It uses the `display` API from IPython to render the snapshot inline, with a default function that shows the DataFrame’s shape. The example highlights a practical debugging pattern for exploratory data analysis workflows.

Aadiamaan92
56% match