/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

2 votes308 views2 answers
Python ping api
Python
0 vote340 views1 answer
Set list start at 1 python
Python
8 votes332 views1 answer
Use beautifulsoup
Python
0 vote384 views2 answers
ImportError: /usr/local/lib/python3.7/dist-packages/cv2/cv2.cpython-37m-arm-linux-gnueabihf.so: undefined symbol: __atomic_fetch_add_8
Python
0 vote330 views1 answer
Summation django queryset
Python
0 vote318 views1 answer
Python click activator
Python
4 votes338 views2 answers
How to exit program in python
Python
0 vote330 views1 answer
How to make a nan value in a list
Python
1 vote311 views1 answer
Numpy slice array into chunks
Python
0 vote340 views1 answer
Test pypi
Python