Aug-08-2020, 12:01 PM
Your csv is wrong formated, delimiter should be tab(you have 3 spaces or 4 four spaces)
my.csv
my.csv
C1 C2 C3 A 20 2020/05/03 20:45:12 B 5 2020/06/23 10:45:12main.py
import logging from datetime import datetime import pandas as pd from read_data import data import sys working_dir = sys.argv[0].rpartition("/")[0] def main(): if __name__ == '__main__': data.read_data(f'{working_dir}/my.csv', colNames ='col1', mode = 'NOM', delimiter = "\t") main()read_data.py
import pandas as pd import logging import sys working_dir = sys.argv[0].rpartition("/")[0] class MyData: def __init__(self): self.mode = None def read_data(self, inFile, colNames, mode, delimiter): self.infile = inFile print("The infile name",inFile) try: self.df = pd.read_csv(inFile, delimiter = "\t") print(self.df.head(2)) self.df.to_csv(f"{working_dir}/final.csv",index=False, sep = "\t") logging.debug("Read data successfully") except OSError as e: logging.debug("File read fail check fail reason below") logging.debug(e.errno) data = MyData()