在Python中如何读取一个CSV数据中的单行?

2024-03-28 15:38:58 发布

您现在位置:Python中文网/ 问答频道 /正文

有很多使用python读取csv数据的示例,如下所示:

import csv
with open('some.csv', newline='') as f:
  reader = csv.reader(f)
  for row in reader:
    print(row)

我只想读取一行数据并将其输入到各种变量中。我该怎么做?我到处找工作的例子。

我的代码只为我检索值,而没有其他值

reader = csv.reader(csvfile, delimiter=',', quotechar='"')
for row in reader:
  i = int(row[0])
  a1 = int(row[1])
  b1 = int(row[2])
  c1 = int(row[2])
  x1 = int(row[2])
  y1 = int(row[2])
  z1 = int(row[2])

Tags: csv数据inimport示例foraswith
3条回答

您可以使用Pandas库从庞大的数据集中读取前几行。

import pandas as pd

data = pd.read_csv("names.csv", nrows=1)

可以在nrows参数中提到要读取的行数。

你可以坐第一排,比如:

with open('some.csv', newline='') as f:
  csv_reader = csv.reader(f)
  csv_headings = next(csv_reader)
  first_line = next(csv_reader)

要只读取csv文件的第一行,请对reader对象使用^{}

with open('some.csv', newline='') as f:
  reader = csv.reader(f)
  row1 = next(reader)  # gets the first line
  # now do something here 
  # if first row is the header, then you can do one more next() to get the next row:
  # row2 = next(f)

或:

with open('some.csv', newline='') as f:
  reader = csv.reader(f)
  for row in reader:
    # do something here with `row`
    break

相关问题 更多 >