Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
Data Wrangling
Command Line mode for faster and more flexible data interaction in Exploratory
Select / Remove Columns
Reorder Columns
Create New Calculation
Create New Calculation for Multiple Columns
Summarize (Aggregate)
Group
Filter
Rename
Arrange (Sort)
Top / Bottom N
Join
Merge
Gather
Spread
Pivot
Expand
Complete
Separate
Unite
Bind Rows
Bind Columns
Keep Only Unique Rows
Keep Only Duplicated Rows
Slice
Drop NA
Sample
Impute NA
Fill
Create Buckets
Assign New Values to Existing Values - Recode
Assign New Values by Setting Conditions - Case When
Work with Categories
Data Type Conversion
Row as header
Ungroup
Unnest
Separate List Items into Columns (Unnest Wider)
Separate List Items into Rows (Unnest Longer)
Separate Address (Japan)
Hoist
Remove Empty Rows
Remove Empty Columns
Clean Column Names
Window Calculation
Window Calculation (日本語)
Add Row
Text Wrangling
Regular Expression Cheat Sheet
Regular Expression Cheat Sheet (日本語)
Visualization
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By GitBook
Sample
Sample n rows from the data frame (Sample N Rows) or sample n fraction of rows from the data frame (Sample Fraction)

How to Access This Feature

Sample (N Rows)

  • Click "+" button and select "Others ..." -> "Sample ..." -> N Rows

Sample (Fraction)

  • Click "+" button and select "Others ..." -> "Sample ..." -> Fraction

Sample (N Rows)

  1. 1.
    Enter Sample Number - Number of rows you want to sample the data. (e.g. 10000)
  2. 2.
    Select Weight Colulmn (Optional) - Sampling weight. The ratio of probability the row should be chosen. This should be non-negative numeric vector whose size is the number of rows. It's normalized so that the sum of the probability will be 1.
  3. 3.
    Replace Sampled Rows (Options) - The default is FALSE. If it's TRUE, replacement will be executed when sampling.
  4. 4.
    Click "Run" to Sample data frame.

Sample (Fraction)

  1. 1.
    Enter Sample Fraction ratio. It should be a numeric value between 0 and 1. (e.g. 0.4)
  2. 2.
    Select Weight Colulmn (Optional) - Sampling weight. The ratio of probability the row should be chosen. This should be non-negative numeric vector whose size is the number of rows. It's normalized so that the sum of the probability will be 1.
  3. 3.
    Replace Sampled Rows (Options) - The default is FALSE. If it's TRUE, replacement will be executed when sampling.
  4. 4.
    Click "Run" to Sample data frame.
Previous
Drop NA
Next
Impute NA
Last modified 8mo ago
Copy link
Contents
How to Access This Feature
Sample (N Rows)
Sample (Fraction)
Sample (N Rows)
Sample (Fraction)