Once you run the code in Python (adjusted to your paths), you’ll get the CSV file at your specified location. Read_file.to_csv (r'C:\Users\Ron\Desktop\Test\New_Products.csv', index=None) Read_file = pd.read_csv (r'C:\Users\Ron\Desktop\Test\Product_List.txt') So this is the complete code to convert the text file to CSV for our example (note that you’ll need to modify the paths to reflect the location where the files are stored on your computer): import pandas as pd Download free Libre office and use spreadsheet program of that to convert into csv. Now your Text file will be opened in Excel.
0 Comments
Leave a Reply. |