Where the new file name to be created is New_Products and the file extension is csv.The path where the CSV will be saved is: C:\Users\Ron\Desktop\Test\New_Products.csv.Where the file name is Product_List and the file extension is txt.The path where the text file is stored is: C:\Users\Ron\Desktop\Test\Product_List.txt.Read_file.to_csv (r'Path where the CSV will be saved\File name.csv', index=None) Read_file = pd.read_csv (r'Path where the Text file is stored\File name.txt') Print("I/O error()\n".C:\Users\Ron\Desktop\Test\New_Products.csv Step 4: Convert the text file to CSV using Pythonįinally, you may use the template below in order to facilitate the conversion of your text file to CSV: import pandas as pd Txt_file = input('Enter the name of your output file: ') # A simple program to create a formatted text file from a *.csv file.Ĭsv_file = input('Enter the name of your input file: ') Now, to be fair, I am new to Python, and this script works perfectly (first try), I would just like some feedback on my methods, or ways to improve my quality of code. This file is an input to another program, and rather than spending the time to copy and paste the excel sheet into notepad and crop out all the commas and make sure there are spaces and such I decided to write a python script that would do it for me. To a regular *.txt file with the structure: #1ĭouble filename(number of columns, number of columns)
At my job, often I have to manually convert *.csv Files structured like: number,number\n
0 kommentar(er)
