proccesing_test_data

from time import time
import pandas as pd

start_time = time()
# ссылка для скачивания тестовых данных:
# nested_data.txt:'https://vk.com/doc207845555_618678979'
path = 'd:\\tmp\\nested_data.txt'
with open(path) as file:
    text = file.readlines()

data = []
for line in text:
    d = line.index('=') # разделитель
    key = line[0:d]
    value = line[d+1:].strip().split(';')
    data.append([key] + value)

df = pd.DataFrame(data)
df.columns = ['key'] + [f'name_{x}' for x in range(1, df.shape[1])]

print(df.head())
print('time:', time() - start_time)

# текст вот такого вида:
# aaad=KA;G;NWA;L;P;NV;YCV;OZE;OOV;I;CI;O;A;SOS;F;AOV;SYY;LN;J;G
# aaag=JYX;RDG;SQN;JV;GXB;RRW;QOU;HD;HNP;VE;MHX;ZNE;V;M;NVW;AF
# aaAg=ORU;BYB;KGP;KUI;X;W;VLH;D;Y;AFQ;SH;EF;S;RRH;QQ;AME;E;KUH;ZEU;SJ;OHX;OHO;KK;S;OYO;F;H;WLJ;W;LF;CAD;Y
# AAaK=SBF;B;M;GHB;WQ;C;M;JGT;IV;J;LJT;K;UD;D;CEX;LNO;V;KYN;LWN;FQJ;UEV;Y;V;QO;P;DO;SLQ;HVP;LQ;C;K;I;V;S;AZ;QY;CD;T;K;R;I;CL;IC;COX
# AaAL=YVF;X;ROZ;TE;DK;MZK;BV;W;Z;JUU;U;E;U;J;JG;UZJ;Q;NNG;CB
# AaBb=KNG;H;HHJ;XAU;J;Y;N;WDY;K;P;YJ;YDF;BL;H;W;LU;TI;UO;W;LK;N;HLT;G;X;V;NO;M;O;GXS;N;X;HP;BC

# преобразован в датафрейм:
#     key name_1 name_2 name_3 name_4  ... name_61 name_62 name_63 name_64 name_65
# 0  aaad     KA      G    NWA      L  ...    None    None    None    None    None
# 1  aaag    JYX    RDG    SQN     JV  ...    None    None    None    None    None
# 2  aaAg    ORU    BYB    KGP    KUI  ...    None    None    None    None    None
# 3  AAaK    SBF      B      M    GHB  ...    None    None    None    None    None
# 4  AaAL    YVF      X    ROZ     TE  ...    None    None    None    None    None