The final progress report. There's a lot left to do. Up until now the project reports have been more of a an update on various different issues that I've run through while code. I expect this one to be a little a different. It will most likely have the final presentation to show how the project ended up. Depending upon how long it takes me to get to that final project.
https://towardsdatascience.com/name-your-favorite-excel-function-and-ill-teach-you-its-pandas-equivalent-7ee4400ada9f
After some tinkering and creating a scratch file. We've got the look up results we want with a simple yet elegant one line of code.
Update: The final is done.Somewhere around 11pm last night, there was an entire rewrite of the functionality of the name swaps to deal with pandas. That led into a fight that lasted to 6am. We now go from start all the way to outputting an new_account sheet. The only thing that's really left to do is figure out how to snag cities with two names. There is out there for parsing addresses. This is not might first time running into this problem. It was a battle.There was a point where I thought I lost the whole thing while branching in git. The final product is just what we wanted though. Simple easy to use program that automates the processes of scrubbing files. It is relatively dynamic. Honestly, might give it to my fiance to help do index(matches()) for work. There is definitely an application there for people that don't know any code.
Presentation Slides:
Conclusions:
This project can go on forever. And it probably will. My goal is to take this and continue building it out. I would like to use machine learning to help better process the names and the addresses. The project picked up an old midterm, and essentially rewrote the whole thing except for two functions. It now includes GUIS and lookups and another file creation. The creation of these GUI's through classes took a while to learn. The good news is that because of the way in which I wrote them, I will be able to pull upon them later on. It was great practice. Pandas were introduced late in the game for the project which lead to a lot of learning during the crunch hours. It brings up the whole fight between creating cleaner code and just writing the code the way that you know how to. I am extremely pleased with the final product, and am excited that it actually functions like a mini program.
Comments
Post a Comment