Skip to main content
SimilarExport ZIP
100%

Gist 575a4d1a506d4f39d35f

✓ Published0🌍 Public
SSav10
Last edited Oct 7, 2021
Created on Mar 31, 2015

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.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist 7083cd8264b6aa48ce4bbfaf44546f07

This example builds a profile-scraping pipeline for social media data, turning raw CSV input into a structured DataFrame with fields for user names, follower counts, post dates, likes, comments, captions, and industry tags. The code reads `raw_data.csv` via `pandas.read_csv` and then initializes an empty DataFrame with predefined column names, preparing it for subsequent population. The visualization focuses on the data-preparation stage rather than graphical output, demonstrating how pandas handles tabular ingestion and schema definition. No rendering library like d3 or Three.js appears here; instead, the emphasis is on clean data structuring for later analysis or charting.

AArizonaTay
68% match
Loading thumbnail…

Gist fa05e9e0684e37e537c08085e5900435

This example shows a data-cleaning pipeline for an Instagram influencer dataset, highlighting the number of unique users and missing values across key columns. The code uses pandas to inspect and transform the data, filling missing industry labels with "General," dropping rows without captions, removing duplicate entries, and converting the post date column to datetime format for time-series indexing. The visualization relies on pandas' built-in data manipulation functions, such as `fillna`, `drop_duplicates`, and `set_index`, rather than a plotting library. The final output would be a cleaned dataframe ready for trend analysis, though no chart is generated in the provided script.

AArizonaTay
67% match
Loading thumbnail…

Gist feea61c798fdb955f16b5ba785974e1a

This example highlights differences between two pandas DataFrames by key. It displays the two records side-by-side, transposing them into a single table where each column represents a field. Any column containing differing values between the two rows is visually marked with a yellow background. The implementation uses the pandas `DataFrame.style.apply` method to apply a custom `highlight_diff` function that checks for uniqueness across the row pairs, returning conditional formatting styles for the table.

JJonasHeylen
62% match
Loading thumbnail…

Created on Cognitive Class Labs

This example demonstrates the process of data wrangling on an automobile dataset using Python. It shows how to import data from a URL into a Pandas DataFrame, assign descriptive column headers, and prepare the data for analysis. The notebook uses Pandas for data manipulation and matplotlib for potential visualization. The dataset is sourced from an IBM-hosted CSV file, and the code handles tasks such as reading the data and setting up the structure for further cleaning and transformation.

DDAVINDER
61% match
Loading thumbnail…

Created on Cognitive Class Labs

This example demonstrates the process of data wrangling on an automobile dataset using Python. It shows how to import data from a URL into a Pandas DataFrame, assign descriptive column headers, and prepare the data for analysis. The notebook uses Pandas for data manipulation and matplotlib for potential visualization. The dataset is sourced from an IBM-hosted CSV file, and the code handles tasks such as reading the data and setting up the structure for further cleaning and transformation.

DDAVINDER
61% match
Loading thumbnail…

Make it pretty - Playing around with CSS, SVG, Animated CSS in Jupyter Notebook

This example demonstrates how to style and animate pandas DataFrames within a Jupyter Notebook using custom CSS and SVG. It applies a fantasy font, colored table headers and cells, and integrates the animate.css library to add animated effects like bouncing. The code injects CSS rules directly into the notebook’s HTML output, transforming standard table rendering into a more visually engaging presentation.

PP3nny
61% match
Loading thumbnail…

Gist d3be7947ba494f0cc785ad4ff966f6d5

This example demonstrates a workflow for collecting and structuring Twitter data through the streaming API. It uses the `tweepy` library to authenticate and open a live stream, filtering tweets by specified terms or hashtags, and saving each raw tweet as a JSON line to a file. The code then reads that file back, parses each tweet, and extracts selected fields into a nested list, including the text, user handle, favorite and retweet counts, timestamp, follower count, and language. Finally, it organizes the data into a structured pandas DataFrame with corresponding column names, preparing it for further analysis or visualization.

GGeorgeMcIntire
60% match
Loading thumbnail…

First steps

This example shows the initial steps of loading and inspecting a malformed CSV file in Python using pandas and basic file handling. It opens the file with the built-in `open()` function, reads it line by line, strips whitespace, and splits each line into a list of values with `split(",")`. The resulting nested list is converted into a pandas DataFrame via `pd.DataFrame`, and the first 20 rows are displayed to examine the data structure. The snippet highlights data cleaning challenges, as many fields contain `None` values and numeric entries are in scientific notation.

RRobinL
59% match