Number of lines is different from what the txt file actually contains

[Aldemir]

@How to arrange this

empty lines but maybe that was the case if not they could be removed.
If data is missing it could be feasible to expand the width.

Then if you have garbage in your data it could be because of UTF-

import pandas as pd

arquivo = r"C:\Users\EFIM\OneDrive - PETROBRAS\Documents\Segment_RCE\Movimentação KE5Z 2020\1 TRI\estoque 0421.txt"

#caminho = r"C:\Users\EFIM\OneDrive - PETROBRAS\Documents\ateste\2021abr.parquet"

define o tipo de cada coluna como string

dtype = {col: str for col in range(0, 21)}

df = pd.read_csv(arquivo, sep=‘|’, encoding=‘ISO-8859-1’, skiprows=9, low_memory=False, dtype=dtype)

knio.output_tables[0] = knio.Table.from_pandas(df)