CODEWITHSUNDEEP
pythonpython-3.xexport-to-text
adura826
adura826

Reputation: 113

Exporting SQL query from Python to txt file

I'm trying to export data that I queried from a database to a txt file. I am able to do so with the .to_csv method however it exports with spaces. I've tried to set the (sep) in the query to no space but it is forcing me to use at least one space or item as a seperator. Is there any way to export data to a txt file and not have any spaces in between export?

dataframe

enter image description here

Code I've been using to export to .txt

dataframe.to_csv('Sales_Drivers_ITCSignup.txt',index=False,header=True)

Want it to export like this:

enter image description here

Upvotes: 2

Views: 2407

Answers (2)

adura826
adura826

Reputation: 113

Took a bit of tinkering but this was the code I was able to come up with. The thought process was to create import the text file, edit it as a list, then re-export it overwriting the previous list. Thanks for all the suggestions!

RemoveCommas = []
RemoveSpaces = []
AddSymbol = []
Removeextra = []

#Import List and execute replacements
SalesDriversTransactions = []
with open('Sales_Drivers_Transactions.txt', 'r')as reader:
    for line in reader.readlines():
        SalesDriversTransactions.append(line)

for comma in SalesDriversTransactions:
    WhatWeNeed = comma.replace(",","")
    RemoveCommas.append(WhatWeNeed)
    
for comma in RemoveCommas:
    WhatWeNeed = comma.replace(" ","")
    RemoveSpaces.append(WhatWeNeed)
    
for comma in RemoveSpaces:
    WhatWeNeed = comma.replace("þ","þ")
    AddSymbol.append(WhatWeNeed)

for comma in AddSymbol:
    WhatWeNeed = comma.replace("\n","")
    Removeextra.append(WhatWeNeed)

with open('Sales_Drivers_Transactions.txt', 'w')as f:
    for i in Removeextra:
        f.write(i)
        f.write('\n')

Upvotes: 0

Usama Tariq
Usama Tariq

Reputation: 179

Try

np.savetext(filename, df.values, fmt)

Feel free to ask question in case of any problem.

Upvotes: 1

Related Questions