How to convert vertical csv file to horizontally

Question 1

I want to convert the inputted csv.data result horizontal to vertical.

This is my code

import csv
with open('p1.csv', newline='') as f:
 reader = csv.reader(f)
 for row in reader:
  rain=(", ".join(row))
  print(rain)

This is the result

4.019310345
6.713103448
1.172413793
2.369655172
0.485517241

I want it to be like below.

4.019310345, 6.713103448, 1.172413793, 2.369655172, 0.485517241

I have tried 'replace' function, it doesn't work. Please help me.

Question 2

Maybe you can try:

import csv
csv_file = r"My_file_path"
with open(csv_file, newline='') as f:
    reader = csv.reader(f)
    rain = []
    for row in reader:
        rain.append(row)   
    print(', '.join(rain))

Here I'm creating a separate list named as rain and after the loop I'm printing the list with the help of join.

Sakshi Sharma · Answer 1 · 2021-11-23T23:42:54

Maybe you can try:

import csv
csv_file = r"My_file_path"
with open(csv_file, newline='') as f:
    reader = csv.reader(f)
    rain = []
    for row in reader:
        rain.append(row)   
    print(', '.join(rain))

Here I'm creating a separate list named as rain and after the loop I'm printing the list with the help of join.

How to convert vertical csv file to horizontally

In other languages

This page is in other languages

Popular in the category