Group 65
Go to Workbench
All Collections
Steps
Steps
Details about how each module works
55 articles in this collection
Written by
Pierre Conti
ADD DATA
Load from URL
Load data from a public URL or a public data API.
Written by
Pierre Conti
Updated over a week ago
Start from tab
Import data from one tab to another. Split your analysis in multiple parts.
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 over a week ago
Twitter
Load tweets from a specific user account, any users, or a from a list
Written by
Pierre Conti
Updated this week
Join workflow
Written by
Pierre Conti
Updated over a week ago
U.S. Community Survey
Import data from the 2017 American Community Survey
Written by
Pierre Conti
Updated over a week ago
Concatenate workflows
Written by
Pierre Conti
Updated over a week ago
Upload file
Import data from a local CSV or Excel file
Written by
Pierre Conti
Updated over a week ago
Google Drive
Load a Google sheet from you Google account
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 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
HTML Scraper
Scrape the entire HTML from webpages in order to extract content
Written by
Pierre Conti
Updated over a week ago
HTML to Table
Extract data from HTML documents and store it in columns
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
Format numbers
Change how numerical values are displayed in specific columns
Written by
Pierre Conti
Updated over a week ago
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 over a week ago
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 over a week ago
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 over a week ago
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
Cluster alternative representations of the same values, and edit or merge them in seconds
Written by
Pierre Conti
Updated over a week ago
Reshape
Change the shape of your data from long to wide format and vice versa.
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 over a week ago
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 over a week ago
Split Column
Divide a column into several columns
Written by
Pierre Conti
Updated over a week ago
ANALYZE
Calculate
Execute simple math operations between columns
Written by
Pierre Conti
Updated over a week ago
Burst detector
Triggers the creation of groups if a set number of events happen in a set time frame
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 and compare data using vertical bars and export images
Written by
Pierre Conti
Updated over a week ago
Scatter plot
Written by
Pierre Conti
Updated over a week ago
Line Chart
Visualize data on a timeline to display change over time
Written by
Pierre Conti
Updated over a week ago
Histogram
Plot numeric data into bins to visualize frequency
Written by
Pierre Conti
Updated over a week ago
Word cloud
Written by
Pierre Conti
Updated over a week ago
CODE
Python editor
Process data with code
Written by
Pierre Conti
Updated over a week ago