/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 vote219 views1 answer
How to solve not in base 10 in python when using decimals
Python
2 votes171 views1 answer
Django.core.exceptions.improperlyconfigured: wsgi application 'backend.wsgi.application' could not be loaded; error importing module.
Python
17 votes238 views4 answers
How to install python 3.6 ubuntu
Python
3 votes213 views1 answer
List in python 3
Python
36 votes205 views4 answers
Python sum
Python
0 vote230 views1 answer
Flask put request example
Python Flask
2 votes165 views1 answer
Combine date and time to datetime pandas
Python
0 vote212 views1 answer
Matlab .* operator in python
Python
0 vote198 views1 answer
Standard streams with python3
Python
1 vote213 views1 answer
Cannot import name 'imputer'
Python