/Python/How to read any random rows in csv

How to read any random rows in csv

Pandas read_csv random rows

import pandas as pd
import numpy as np

filename = 'hugedatafile.csv'
nlinesfile = 10000000
nlinesrandomsample = 10000
lines2skip = np.random.choice(np.arange(1,nlinesfile+1), (nlinesfile-nlinesrandomsample), replace=False)
df = pd.read_csv(filename, skiprows=lines2skip)

Source: stackoverflow.com

How to read any random rows in csv

import pandas as pd

data = {
		'Name': ['A', 'B', 'C', 'D', 'E', 'F'],
		'Age': [10, 20, 30, 40, 50, 60]
        }

df = pd.DataFrame(data)
print(df.sample(n=2))   # where 2 is the number of random rows

Similar codes

0 vote233 views1 answer
Add field placeholder layout crispy modelform
Python
30 votes249 views3 answers
How to replace null values in pandas
Python
0 vote255 views1 answer
Pandas group by multiple columns and count
Python
0 vote191 views1 answer
Xgboosat save_model
Python
2 votes238 views1 answer
Module 'pygame' has no 'init' member
Python
3 votes248 views3 answers
List slicing in python
Python
27 votes274 views3 answers
Sns set figure size
Python
1 vote222 views1 answer
Python how to use a variable to trigger an event
Python
0 vote196 views1 answer
"api_view" is not defined django
Python
0 vote264 views1 answer
Identity matrix in python
Python