Joining multiple Excel files with Python
Sometimes we find the data we need only to realise they are scattered across dozens or hundreds of Excel reports, divided by year, month etc. They have the same structure, they're could be even nice for a human being to read, but they're the worst to anything with data analysis applications. A copy paste nightmare awaits anyone who wants to create one clean and nice spreadsheet with the consolidated data. This hands-on session will teach beginners in Python how to write a simple script that will extract the information from the Excel files and join them together in one CSV for further analysis.
This session is good for: Journalists who can do a little bit of programming and want to sharpen their skills.
What you need to know: a little bit of Python, will go slower for beginners.
На этой странице сайта вы можете посмотреть видео онлайн Joining multiple Excel files with Python длительностью часов минут секунд в хорошем качестве, которое загрузил пользователь International Journalism Festival 06 Апрель 2016, поделитесь ссылкой с друзьями и знакомыми, на youtube это видео уже посмотрели 12,708 раз и оно понравилось 44 зрителям. Приятного просмотра!
