There are several methods to read a specific number of rows from a CSV file, but here are three common ways to do so:
import csv
with open('file.csv', 'r') as file:
reader = csv.reader(file)
row_count = 0
num_rows = 10 # Set the number of rows to read
for row in reader:
if row_count < num_rows:
print(row)
row_count += 1
else:
break
islice
function from the itertools
module:import csv
from itertools import islice
with open('file.csv', 'r') as file:
reader = csv.reader(file)
num_rows = 10 # Set the number of rows to read
for row in islice(reader, num_rows):
print(row)
import pandas as pd
df = pd.read_csv('file.csv', nrows=10)
print(df)
Each method has its advantages and disadvantages depending on your use case, so choose the one that suits your needs the best.
Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss
Asked: 2023-06-09 20:25:37 +0000
Seen: 16 times
Last updated: Jun 09 '23
What is the method of enabling undercurl in alacritty on Windows?
How can I install Beegfs on Ubuntu 22.04?
How can a .zip file from GitHub be loaded into Google Colab?
What is the process of using the Multmerge() function in r to combine files in a directory?
In Mac, what is the method to increase the privileges of an executable through setuid?
What can be done to resolve the issue with the Untracked working tree file named '._.git'?