Save array to python CSV

Question

I wrote the code below to store some data in a dataframe, soon after I converted it into an array, but when saved the same in CSV file, the same jumps lines in saved file

import pandas as pd
import csv

df1 = pd.read_csv("CSSS.csv",  encoding="UTF-8", sep=";", usecols=["CPF"])
df2 = pd.read_csv("CSSS.csv",  encoding="UTF-8", sep=";", usecols=["Login"])

df = pd.concat([df1,df2], axis=1)
df_array = df.values


with open("crl.csv", "wt") as csv_output:
    writer = csv.writer(csv_output, delimiter=";")
    writer.writerow(["CPF", "Login"])

    for d in df_array:
        writer.writerow(d)

follows how the CSV file

Answer 1

With the very pandas you can do it, it ta function to_csv who does exactly what you want

df.to_csv("crl.csv",index=False,sep=";")

documentation and references:

to_csv