How to Create Data Frame using multiple text files using python

Question

I Need to Create Data Frame Using Multiple text files, all the text files are in same directory

Text File Format, each text file contains data showed in image

here I need to create DataFrame using these kind of multiple text files

check stackoverflow.com/a/26415986/17489380 for a similar question and answer — Marvo
– Marvo, Commented Aug 30, 2022 at 11:46
You can load them in separate dataframe and use join, merge, or concat — user16181
– user16181, Commented Aug 30, 2022 at 11:52
Does this answer your question? Read multiple *.txt files into Pandas Dataframe with filename as column header — Daniel Fainberg
– Daniel Fainberg, Commented Aug 30, 2022 at 13:45

Stager · Accepted Answer · 2022-08-30 11:53:12Z

0

If it is possible to remove the last line (Name: 45559, dtype: object) then you should be able to load txt file as a csv:

import pandas as pd
import os


txt_files_dir = '...'
files = os.listdir(txt_files_dir)
dfs_list = [pd.read_csv(file, sep='\s+') for file in files]
data_frame_result = pd.concat(dfs_list, axis=0, ignore_index=True)

answered Aug 30, 2022 at 11:53

Stager

13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Hemanth Kumar Over a year ago

no need keep last line, we need only first 20 rows from text file

Stager Over a year ago

in that case you can preprocess the file beforehand to remove the last line and use the posted code snippet

Collectives™ on Stack Overflow

How to Create Data Frame using multiple text files using python

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related