I am trying to loop through a .csv file so I can read each line, but I am receiving the following error:
AttributeError: '_io.TextIOWrapper' object has no attribute 'iterrows'
Here is my code so far:
def i_list(input_file):
input_list = []
file = open(input_file, 'r')
for i, j in file.iterrows():
num1 = j[1]
num2 = j[2]
input_list.append(num1)
input_list.append(num2)
i_list('nums.csv')
You can use the csv library
import reader from csv
input_list=[]
f = reader(open(input_file))
header = next(f) # if there is a header
for num1, num2 in f:
input_list.append(num1)
input_list.append(num2)
You can use Pandas:
import pandas as pd
df = pd.read_csv('file.csv')
for row in df.iterrows():
# do something
If you don't want to use Pandas, try to read the file using: file.readlines()
with open(filepath, 'r') as f:
lines = f.readlines()
for line in lines:
# do something
readorreadlineforiterrows