I am quite new to python and am trying to write to a specific cell in a csv file but I can't quite figure it out.
This is part of it, but I don't know how to get it to write the score (line 3) to the cell I want. e.g cell "B1":
file = open(class_name + ".csv" , 'a')
file.write(str(name + " : " ))
file.write(str(score))
file.write('\n')
file.close()
Pandas will do what you're looking for
import pandas as pd
# Read csv into dataframe
df = pd.read_csv('input.csv')
# edit cell based on 0 based index b1=1,0
df.ix(1,0) = score
# write output
df.to_csv('output.csv', index=False)
There is a CSV reader/writer in python that you can use. CSV files don't really have cells, so I will assume that when you say "B1" you mean "first value in second line". Mind you, that files do not behave the way a spreadsheet behaves. In particular, if you just start writing in the middle of the file, you will write over the content at the point where you are writing. Most of the time, you want to read the entire file, make the changes you want and write it back.
import csv
# read in the data from file
data = [line for line in csv.reader(open('yourfile.csv'))]
# manipulate first field in second line
data[1][0] = 'whatever new value you want to put here'
# write the file back
csv.writer(open('yourfile.csv', 'w')).writerows(data)
data = [line for line in csv.reader(open('yourfile.csv'))] preferred over something simpler like data = list(csv.reader(open('yourfile.csv'))) since you're pulling out all the data either way?
You just have to separate your columns with commas and your lines with linebreaks. There's no mystery:
name1 = "John"
name2 = "Bruce"
job1 = "actor"
job2 = "rockstar"
csv_str = ""
csv_str += name1 +";"+job1+"\n" #line 1
csv_str += name2 +";"+job2+"\n" #line 2
file = open(class_name + ".csv" , 'a')
file.write(csv_str)
file.close()
This will generate a 2x2 grid
B1but csv files are not addressable as rows/colums. You can create a list of lists (basically a list of rows) do the update and then save.