How to remove spaces in CSV

Question

Below is the current code that yields extra spaces after appending logs/events:

import csv

#MANUAL ENCODES

logs = [["TT5134", "XACG2M756B2ZP0", "2055243", "ref die", "abort;play", "closed"]
        ]

#FILE DUMP

with open(r"\\xcl3090dm1\checkout_eagle\ETS\PE_Downs(DONOTDELETE)\SR_Data.csv", "a") as csv_file:

    reports = csv.writer(csv_file)

    reports.writerows(logs)

Assuming I have next logs/event to input, there will be space produce. How can I use the strip() function on my existing code? I tried to insert this function but I either failing to remove the space or producing errors.

score 0 · Answer 1 · answered Dec 29 '22 at 14:07

0

Use Pandas

import pandas as pd
pd.read_csv("\xcl3090dm1\checkout_eagle\ETS\PE_Downs(DONOTDELETE)\SR_Data.csv", sep=',',header=0)

If necessary:

df.dropna(inplace=True)

answered Dec 29 '22 at 14:07

razimbres

4,715
5
23
50

hi thank you, all I need to do is to add parameter newline='' in open function. Already solved my question! :) – jaypeeee10 Dec 29 '22 at 15:10
Post as an answer =) – razimbres Dec 29 '22 at 15:42

How to remove spaces in CSV

1 Answers1