Primary competition visual

SFC PAYGo Solar Credit Repayment Competition

Helping Africa
$5 000 USD
Completed (over 4 years ago)
Prediction
1060 joined
275 active
Starti
Jun 06, 21
Closei
Aug 29, 21
Reveali
Aug 29, 21
User avatar
underfitting
Church of christ
Transaction dates
Data · 14 Jul 2021, 05:54 · 4

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.

Discussion 4 answers
User avatar
flamethrower

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.

14 Jul 2021, 06:25
Upvotes 0
User avatar
underfitting
Church of christ

Thank you @DamolaOr. That's a brilliant approach, I will try it. I will be able to figure out the code.

User avatar
flamethrower

You are welcome, let me know if you have any challenges with it.

User avatar
underfitting
Church of christ

Thanks, @DamolaOr.