I have the following sample data. I need to extract all fields between <NetworkPayeeAddManager>
and </NetworkPayeeAddManager>
or between <PayeeAddManager>
and </PayeeAddManager>
and save all information to Pandas DataFrame. I would expect the output dataframe has columns from first "TenantId" to last "AccountNumber" with values such as 13744, XX2222. What's the best way to do it?
OrderedDict([('_raw', '2021-11-08 08:58:23,832 [42] INFO FiservLog.stdlog - 13744 999176993878 LogInfoSecure 234 NetworkPayee was added successfully <Timestamp>2021-11-08T13:58:23.831628ZF7E65ED4D8C74E6699C62F23ECF5D000200TWNQ9X1AA1754513234A6367FEE06 11/8/2021 1:58:23 PM 2461b5d9839a46739e9a3e918ca0681b-01 Louisville fire brick {"Address1":"Po 9229","Address2":null,"City":"Louisville","State":"KY","Zip5":"40209","Zip4":null,"Zip2":null}UnManagedPayee XX2222 ')])
OrderedDict([('_raw', '2021-11-08 08:58:24,783 [105] INFO FiservLog.stdlog - DI737 344801483 LogInfoSecure 234 Payee was added successfully 2021-11-08T13:58:24.7831103Z 7FC6442718864CE4838E50B026C8D0A0000TWNXSV1721BE0D804F295706DD39E 11/8/2021 1:58:24 PM ab33b59c-756e-4144-ad62-6f0afadbe8eb Gail Nezworski {"Address1":"2280 S 460 E","Address2":null,"City":"LaGrange","State":"IN","Zip5":"46761","Zip4":null,"Zip2":null}UnManagedPayee XXXXX1888 ')])
