擅长:python、mysql、java
<p>我感谢<strong>SamBob</strong>的帮助,以下是最终解决方案,以防任何人需要:</p>
<pre><code>import itertools
import pandas as pd
pd.options.display.width = 0
def parse_file(filename):
indices=[0,1,12,16,17,18,42] # list of indexes
parsed_data = [] # return a list
with open(filename) as f:
header = next(f)
data_mov = header[18:26]
for line in itertools.islice(f,1,100):
# dividr de acordo com os índices.
parts = [data_mov] + [line.rstrip()[i:j] for i,j in zip(indices, indices[1:]+[None])]
parsed_data.append(parts)
# convert to dataframe
cols = ['data_mov', 'chave_detalhe', 'cpf_cliente','cd_clube','cd_operacao','filler','cd_retorno','tx_recusa']
df = pd.DataFrame(parsed_data, columns=cols)
return df
df = (parse_file("filename.txt"))
</code></pre>