python - pandas/python script for converting to pipe ftext file

Question

Consider the below data in Excel (.xlsx) format as Input file.Assume the location is C:\Conversion\input.xlsx

The output file should be in the below pipe limited format as text file. the output should be in the below locations C:\Conversion\output\pip.txt

Please help by providing a Python/pandas script for the above output. Note: I am a new learner.

• The output txt file should not contain any junk and bad character.
• if the value is blank any cell (input file), it need to store as null value.

Thanks in advance

标签： pythonpandas

Answer 1

I may be wrong, but this is found in your computer settings. By default your computer is comma delimited. Go to the control panel and find additional settings. There you can change the list separator from commas to pipes.