How to add data in Pandas Dataframe dynamically using Python?

Use read_csv for read txt file:

names = [f"Column {i}" for i in range(1, 9)]
df = pd.read_csv(file, sep="\s+\|\s+", names = names, header=None)
    
print (df)
       Column 1     Column 2     Column 3    Column 4     Column 5  Column 6  \
0         Lorem        Ipsum           is      simply        dummy      None   
1          text           of          the    printing          and      None   
2   typesetting    industry.        Lorem        None         None      None   
3          more     recently         with     desktop   publishing  software   
4         Ipsum          has         been         the   industry's      None   
5      standard        dummy         text        ever        since       the   
6          took            a       galley          of         type       and   
7     scrambled           it           to        make            a      type   
8            It          has     survived         not         only      five   
9           the         leap         into  electronic  typesetting      None   
10    remaining  essentially    unchanged        None         None      None   
11           It          was  popularised          in          the     1960s   
12        Lorem        Ipsum    passages,         and         None      None   
13    PageMaker    including     versions          of        Lorem     Ipsum   

      Column 7 Column 8  
0         None     None  
1         None     None  
2         None     None  
3         like    Aldus  
4         None     None  
5        1500s     None  
6         None     None  
7     specimen     book  
8   centuries,      but  
9         None     None  
10        None     None  
11        with      the  
12        None     None  
13        None     None  

You can do it by creating a series for each line and then creating the dataframe by concatenating those series.

import pandas as pd

with open(file) as f:
   data = f.read().split('\n')

lines = []

for i in data:
    row = i.split(' | ')
    lines.append(pd.Series(row))

df = pd.concat(lines, axis=1).T

You will dynamically get the right number of columns. The columns will be named just 0, 1, 2... but if you need to rename them to Column 1, Column 2... you can easily do it via:

df = df.rename(columns={c: f"Column {c}" for c in df.columns})

Are you trying to append 5 columns to a dataframe with 8 columns, right? Try to read this Append Dataframe with Different Number of Columns. And also check this documentation Ways to Merge Data on Pandas.

Probably it's enought to solve this problem