In this video, I show you how I merged over 90 separate Excel spreadsheets and CSV files into one master file with around 100,000 rows. This isn't a step-by-step tutorial, but I do walk you through the process I used, including the Python code I wrote with the help of ChatGPT. The code handles different table formats, duplicates, and more. You can find the complete code on my GitHub (github.com/dwainbrowne/clean-.... If you find this helpful, please like and subscribe!
00:00 Introduction
01:49 Python Script
03:32 Excel File Example
05:32 Using the Script
Watch more videos in this playlist: • Productivity
-------------------------------------------
About this Channel:
-------------------------------------------
This channel is where I share all my unfiltered thoughts on coding, tech, and the everyday struggles I face. I know this style might not be everyone's cup of tea. If you need more structured tutorials on starting a business and becoming a tech entrepreneur, then head over to my other channel: / @dwainbrowne
-------------------------------------------
Checkout my Playlist:
-------------------------------------------
Technology:
• LastPass, we're done! ...
Software Development: • Chat GPT-4 - A Game C...
Entrepreneur:
• Silicon Valley Bank Co...
-------------------------------------------
Find out more about me:
-------------------------------------------
Personal Website: www.dwain.me
My Company: www.snapsuite.io
-------------------------------------------
Connect with me - Social Media Links
-------------------------------------------
LinkedIn: / dwainbrowne
Twitter: / dwainbrowne
Instagram: / dwainbrowne
-------------------------------------------
My Gear (Affiliate Links):
-------------------------------------------
Graphics Tablet: amzn.to/3Tzgqjq
Webcam: amzn.to/3YYoZVY
Video Light: amzn.to/42quuQg
USB Mic: amzn.to/3JqKbhD
DSLR Camera: amzn.to/3LzABvq
DSLR Lens: amzn.to/404KA0f
#entrepreneur #technology #chatgpt #dwainbrowne