/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 vote149 views1 answer
Python empty array length n grepper
Python
0 vote202 views1 answer
Exception Type: AssertionError Exception Value: Expected a `Response`, `HttpResponse` or `HttpStreamingResponse` to be returned from the view, but received a `<class 'django.db.models.query.QuerySet'>`
Python Django
0 vote154 views1 answer
Selenium proxy with authentication
Python
31 votes143 views3 answers
Add element to list python at index
Python
0 vote156 views1 answer
What is primary key in python
Python
0 vote142 views1 answer
Csv file sort python
Python
0 vote96 views1 answer
How to use constructor of base class in derived class in python
Python
0 vote166 views1 answer
Fibonacci series recursive python
Python
2 votes135 views1 answer
Pandas series select first value
Python
0 vote145 views1 answer
Run for loop inside pdb
Python