How to append a contents of text file to a column in dataframe (pandas python)
You can concatenate the files to one file with a delimiter of your choice (make sure that the delimiter is not included in any of the text files), and then use pd.read_csv() to read the concatenated file.
There are bunch of text files in a directory. I want to add each text file to the last column in a row. Can this be achieved using pandas?
Eg:
Directory1>

File1.txt
File2.txt
File3.txt.... (Size of these files are close to 70KB)

Dataframe:
Column1      Column2      column3
Value1       Value2       (Trying to add File1.txt content here)
Is it possible using pandas? Thank you