/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 vote105 views1 answer
Conditional Statements to Skip Items enumerate python
Python
0 vote108 views4 answers
How to open a dataset in netcdf4
Python
-2 votes133 views1 answer
Django modelform datetime
Python Django
0 vote146 views1 answer
Python tuples number Multiplication
Python
0 vote116 views1 answer
How to add to beginning of linked list python
Python
2 votes106 views1 answer
Python hashlib.sha512()
Python
-1 vote138 views2 answers
Django connection cursor
Python Django
6 votes164 views2 answers
Flask form options
Python Flask
0 vote123 views1 answer
How to find the medium, first, second and third quartile in a pandas data frame
Python
0 vote117 views1 answer
Migrations.rename_field django
Python