Feb-28-2018, 08:04 AM
hi,
i have muliple csv's , i am writing a module that can read multiple csv's and take one cell position and pick it's value and append it to new csv file with the file name:
till now i have reached here:
i have muliple csv's , i am writing a module that can read multiple csv's and take one cell position and pick it's value and append it to new csv file with the file name:
till now i have reached here:
import csv import glob import os finaldata = [] listcsv = glob.glob("*.csv") for i in listcsv: filename = os.path.split(i)# here read csv finaldata.append(filename) with open(i, "rb") as csvfile: reader = csv.reader(csvfile) for row in reader: Rnum = row[0] cell2 = row[1][4]# cell position is b5 filedata.append(cell2) filename = "Rahu_ketu.csv" with open(filename, "w")as csvfile: csv = csv.writer(csvfile) csv.writerow("") for i in range(0, len(filedata)): csvfile.writerow(filedata[i])whenever i run this code it says
Error:Traceback (most recent call last):
File "C:\Users\prince.bhatia\Desktop\task_500\task_500.py", line 15, in <module>
cell2 = row[1][4]# cell position is b5
IndexError: string index out of range
can anyone tell me how can i pick that specific cell position and can also take file name and append it to new csv...every csv has same cell position which needed to be picked