Convert Csv File With Values Spareted In Comma To Multi Columns Csv File

I want to create a small program to convert a CSV file with one column containing values separated by comma, to CSV file containing multiple columns with one value: input file: ou

Solution 1:

There are two problems with your code. Firstly, there is no need to use zip(), instead you should create a list of lists by simply rows = [my_list1,my_list2,my_list3]. The difference between the two can be seen by printing the result:

rows_zip = zip(my_list1,my_list2,my_list3)
rows_list = [my_list1,my_list2,my_list3]

print (list(rows_zip))
#[('A', 'A', 'A'), ('B', 'B', 'B'), ('C', 'C', 'C'), ('D', 'D', 'D'), ('E', 'E', 'E')]

print (rows_list)
#[['A', 'B', 'C', 'D', 'E'], ['A', 'B', 'C', 'D', 'E'], ['A', 'B', 'C', 'D', 'E']]

Secondly, you need to pass the whole list my_list1 into writer.writerow() as this writes the whole row of the csv file. Therefore, you only need one loop, which iterates through your list of lists:

my_string1 ='A,B,C,D,E'
my_string2 ='A,B,C,D,E'
my_string3 ='A,B,C,D,E'
my_list1 = my_string1.split(",")
my_list2 = my_string2.split(",")
my_list3 = my_string3.split(",")

path ='C:\Dokumente\\n_1.csv'rows= [my_list1,my_list2,my_list3]

withopen(path, "wb") as csv_file:
    writer = csv.writer(csv_file, delimiter=',')
    forrowinrows:
        writer.writerow(row)

Solution 2:

save it as an excel file, CSV is by definition one column separated by commas, colons, etc. In your code you are splitting a string, and then writing them again separating by commas, undoing what you just did before.

You could just use pandas, load the CSV file and save it to excel format

df=pandas.read_csv("file.csv")
    df.to_excel(filename)