Group 65
Go to Workbench
All Collections
Modules
Modules
Details about how each module works
51 articles in this collection
Written by
Pierre Conti
ADD DATA
Add from URL
Load data from a public URL or a public data API.
Written by
Pierre Conti
Updated over a week ago
Concatenate tabs
Merge multiple tables from several tabs by appending rows
Written by
Pierre Conti
Updated this week
Twitter
Get tweets and metadata
Written by
Pierre Conti
Updated over a week ago
Join workflow
Written by
Pierre Conti
Updated this week
U.S. Community Survey
Import data from the 2017 American Community Survey
Written by
Pierre Conti
Updated this week
Concatenate workflows
Written by
Pierre Conti
Updated this week
Upload file
Import data from a local CSV or Excel file
Written by
Pierre Conti
Updated over a week ago
Join tabs
Merge tables by joining separate tabs using shared columns
Written by
Pierre Conti
Updated this week
Google Drive
Load a Google sheet from you Google account
Written by
Pierre Conti
Updated over a week ago
Paste data
Paste data from a spreadsheet or type it in
Written by
Pierre Conti
Updated over a week ago
SCRAPE
Scrape HTML
Load the entire HTML from a list of URLs to find content and monitor changes
Written by
Pierre Conti
Updated over a week ago
Scrape table
Load an HTML table from a webpage and monitor changes over time
Written by
Pierre Conti
Updated over a week ago
Scrape with XPath
Scrape specific content on a webpage (such as a list) and monitor changes over time
Written by
Pierre Conti
Updated over a week ago
CLEAN
Convert to text
Convert a column type from number or date to text
Written by
Pierre Conti
Updated over a week ago
Convert to date & time
Convert column type from text or number to date-time
Written by
Pierre Conti
Updated over a week ago
Clean Text
Clean several columns of text all at once
Written by
Pierre Conti
Updated over a week ago
Reorder columns
Log the origin and arrival position of columns that are moved
Written by
Pierre Conti
Updated this week
Convert to numbers
Convert columns from text to number and extract numerical values from text values
Written by
Pierre Conti
Updated over a week ago
Deduplicate
Delete duplicate rows by comparing values in one or several columns
Written by
Pierre Conti
Updated this week
Drop empty columns
Filter out all empty columns at once
Written by
Pierre Conti
Updated over a week ago
Rows to header
Turn any row in your data into the table's header
Written by
Pierre Conti
Updated this week
Drop empty rows
Delete rows with empty values
Written by
Pierre Conti
Updated over a week ago
Drop rows
Written by
Pierre Conti
Updated over a week ago
Edit cells
Edit cells in the body of the table
Written by
Pierre Conti
Updated over a week ago
Fill empty cells
Copy values from adjacent rows
Written by
Pierre Conti
Updated over a week ago
Merge columns
Combine two columns into one
Written by
Pierre Conti
Updated over a week ago
Regex extractor
Extract parts of a column using regular expressions
Written by
Pierre Conti
Updated over a week ago
Rename columns
Written by
Pierre Conti
Updated over a week ago
Refine
Automatically cluster alternative representations of the same values, edit and merge to clean your data in seconds
Written by
Pierre Conti
Updated over a week ago
Reshape
Change the format of your data from wide to long and long to wide.
Written by
Pierre Conti
Updated over a week ago
Transpose
Turn rows into columns by swapping a table's header with its left-most column
Written by
Pierre Conti
Updated this week
Select columns
Select columns to keep or drop
Written by
Pierre Conti
Updated over a week ago
Search and replace
​Search the entire table for specific values and replace them
Written by
Pierre Conti
Updated over a week ago
Duplicate column
Duplicate columns. Any time, any place.
Written by
Pierre Conti
Updated this week
Split Column
Divide a column into several columns
Written by
Pierre Conti
Updated over a week ago
ANALYZE
Burst detector
Group and count events that happen in a specific timeframe
Written by
Pierre Conti
Updated over a week ago
Filter
Written by
Pierre Conti
Updated over a week ago
Filter by text
Keep rows containing specific text, or match by regular expression.
Written by
Pierre Conti
Updated over a week ago
Formulas
Use Excel or Python formulas and store the result in a new column
Written by
Pierre Conti
Updated over a week ago
Group
Group and count rows
Written by
Pierre Conti
Updated over a week ago
Count by date
Count rows by time period
Written by
Pierre Conti
Updated over a week ago
Metadata report
Analyze the composition of each column in your table.
Written by
Pierre Conti
Updated over a week ago
Sentiment analysis
Interpret if a text has an overall positive or negative connotation
Written by
Pierre Conti
Updated over a week ago
Sort
Written by
Pierre Conti
Updated over a week ago
SQL Select
Use SQL SELECT statement to query data
Written by
Pierre Conti
Updated over a week ago
VISUALIZE
Column chart
Visualize data and export images
Written by
Pierre Conti
Updated over a week ago
Scatter plot
Written by
Pierre Conti
Updated this week
Line Chart
Visualize data on a timeline
Written by
Pierre Conti
Updated over a week ago
Histogram
Plot numeric data into bins to visualize frequency
Written by
Pierre Conti
Updated this week
Word cloud
Written by
Pierre Conti
Updated this week
CODE
Python editor
Process data with code
Written by
Pierre Conti
Updated over a week ago