Hi everyone. I have a problem here, I am not able to split transaction dates and payment history into separate entities or columns. Anyone can give me ideas on how I can overcome this challenge.
How are you utilizing the transaction dates and payment history columns? I can see that those columns contain lists of dates and payments.
Feel free to drop a comment below.
Hello,
Depends on how you are approaching the task.
You can just extract statistics from the payment and transactions or if you need all the information, you can pad with zeros to a maximum length since they all have variable length.
Use ast.literal_eval to have the string as a list then perform list manipulation to extract values in a list to columns. The exact code you can figure out.
Thank you @DamolaOr. That's a brilliant approach, I will try it. I will be able to figure out the code.
You are welcome, let me know if you have any challenges with it.
Thanks, @DamolaOr.