/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

5 votes134 views1 answer
Check if special character in string python
Python
19 votes126 views2 answers
Ignore warnings
Python
6 votes143 views1 answer
Pd.set_option('display.max_columns', 200) pd.set_option('display.max_rows', 100)
Python
0 vote126 views1 answer
Bag of word scikit learn
Python
1 vote129 views2 answers
String array to float array python
Python
0 vote157 views1 answer
Input function in django
Python Django
7 votes159 views1 answer
Smtp email template
Python
2 votes140 views1 answer
Python convert a string to a list of words
Python
1 vote162 views1 answer
Django round 2 decimal
Python Django
23 votes144 views2 answers
Flask or django
Python