Sampling Data with Pandas

Python

Data Preprocessing

 1|  # samples a random 1000 rows from df
 2|  sample = df.sample(n=1000, random_state=101)
 3|  
 4|  # samples a random 10% of rows from df
 5|  sample = df.sample(frac=0.1, random_state=101)
 6|  
 7|  # samples a random 10% of rows from df but allow rows to be included
 8|  # more than once
 9|  sample = df.sample(frac=0.1, replace=True, random_state=101)
10|  
11|  # samples a random 1000 rows from df but sets the chance of a row being 
12|  # included according to the value in the 'row_weight' columns of df
13|  sample = df.sample(n=1000, weights='row_weight', random_state=101)

DETRO

1 Upvote

Tags: Sample

Did you find this snippet useful?

Sign up to bookmark this in your snippet library

Normalize Windowed Time Series

Python

Data Preprocessing

Scaler | Normalize | Scale | Min-max

4

Convert All Non-numeric Columns to Category Data Types

Python

Data Preprocessing

4

Creating a Running Total Column in Pandas

Python

Data Preprocessing

3

Pivoting Pandas Dataframes

Python

Data Preprocessing

3

Renaming Columns in a Pandas Dataframe Using Dictionaries & Lists

Python

Data Preprocessing

2

How to Remove Punctuation From Text with Python

Python

Data Preprocessing

Nlp | String | Punctuation

2

How To Set First Row of a Pandas Dataframe as Column Headers

Python

Data Preprocessing

2

How to Create Different Aggregations Using GroupBy, Agg & Dictionaries

Python

Data Preprocessing

2

Using Pandas GroupBy Transform Function

Python

Data Preprocessing

Transform | Groupby

2

Extract Date & Time Features From a Pandas Date Column

Python

Data Preprocessing

2