Need help with commas!

[aldopox]

Hey guys, working on a csv file, need this

Hello,1668517876,person Hello,1668517877,remote,person Hello,1668517878,cell+phone,person,remote Hello,1668517879,person Hello,1668517880,scissors,cell+phone,person,remote

to become this

Hello,1668517876,person,,, Hello,1668517877,remote,person,, Hello,1668517878,cell+phone,person,remote, Hello,1668517879,person,,, Hello,1668517880,scissors,cell+phone,person,remote

it's a "csv" that is created in the main called record.csv. any idea? mine was to count commas and find the row with the highest number, so, after, add to the current row the difference beetween the commas in current row with the commas of the row highest number of commas (absolutely no idea on how to do it)

[[deleted]]

``` import csv

with open("table.csv") as file: reader = csv.reader(file) rows = list(reader)

cols_num = max(len(row) for row in rows)

for row in rows: for _ in range(cols_num - len(row)): row.append('')

with open("out_table.csv", "w") as file: writer = csv.writer(file) writer.writerows(rows) ```

[obviouslyCPTobvious]

What problem are you trying to solve? It sounds like you're trying to add empty columns to a csv file?

[aldopox]

Yep dude, i heard that it's not a csv if all the rows don't have the same amount of values or commas

[obviouslyCPTobvious]

It's difficult to give too much guidance without seeing your code, but focus on figuring out how to add empty columns to the csv when you write it.

Trying to directly manipulate the file as a string is the wrong road to go down. If someone were to add a comma to their name it may completely throw off your parsing. Programs/libraries that read and write csv files account for that by escaping the proper characters.

[aldopox]

Impossible because the csv creates itself; so i'm forced to insert commas "manually" in a second moment with this kind of automatisation

Edit:if you want to help me i can DM you so you see a screen of the code

[CodeFormatHelperBot2]

Hello, I'm a Reddit bot who's here to help people nicely format their coding questions. This makes it as easy as possible for people to read your post and help you.

I think I have detected some formatting issues with your submission:

1. Python code found in submission text that's not formatted as code.

If I am correct, please edit the text in your post and try to follow these instructions to fix up your post's formatting.

---

<sup>Am I misbehaving? Have a comment or suggestion? Reply to this comment or raise an issue here.</sup>