at this point i just really want a good programmer to come in and fix all my code and pat me on the head and make everything okay cause im about to start crying from frustration here
ive hit the point where i got 90% of what i need to do finished, but the code is messy and weird and slow, and the last tiny 10% is confusing af and i cant get the motivation to do it cause its only the last bit and i just wanna be saved by an all powerful diety
The fake sample data can be very small … even just 50 survey respondents. You can give them fake names and inputs in places.
Important thing is the columns match.
That should be enough for a coder to test/finish the program, which you can then run on the real data
The easiest doable way is to export to Excel, preserve a master copy and then start manually adjusting things. Labor intensive but you can chip away at it at least
Just use numpy to generate fake data. If you want within a range, you can np.random.randint(). If you want to generate random dates you can use http://pd.to_datetime() and give unit as ‘a’.
And just loop through columns using a for loop and create a new data frame