Parse an Excel File of NBA Stats with Openpyxl

PyBay 2018: Data stored in Excel spreadsheets can be hard to read with anything other than Excel and it’s especially tough to compare two specific datasets within all that data. One possible solution? Let Python do the dirty work of finding the information for us! We'll read NBA statistics with the Openpyxl library and we'll also get the audience involved.

Transcript

1. PARSE NBA STATS W/ OPENPYXL L IZ ZI E S I EG LE @LIZZIEPIKA
2. - DEVELOPER EVANGELIST AT TWILIO - LIKES [PEOPLE, PYTHON, AND © 2017 TWILIO, INC. ALL RIGHTS RESERVED. @LIZZIEPIKA
3. @LIZZIEPIKA OPENPYXL 101
4. - DEVELOPER EVANGELIST AT TWILIO - LIKES [PEOPLE, PYTHON, AND © 2017 TWILIO, INC. ALL RIGHTS RESERVED.
5. ALTERNATIVES @LIZZIEPIKA - LibreOffice Calc - OpenOffice Calc
6. USE CASES @LIZZIEPIKA - Copy + paste - Pick a few rows from many - Search through spreadsheets M e thinking about doing any of these
7. - DEVELOPER EVANGELIST AT TWILIO - LIKES [PEOPLE, PYTHON, AND © 2017 TWILIO, INC. ALL RIGHTS RESERVED. https://pip.pypa.io
8. @LIZZIEPIKA OPENPYXL CODE
9. WORKBOOKS, WORKSHEETS @LIZZIEPIKA
10. MOAR WORKBOOKS, WORKSHEETS @LIZZIEPIKA
11. WRITE TO A SHEET (1) @LIZZIEPIKA
12. @LIZZIEPIKA
13. @LIZZIEPIKA REFERENCING CELLS
14. WRITING IMAGES @LIZZIEPIKA
15. @LIZZIEPIKA
16. OVERWRITE A SHEET @LIZZIEPIKA
17. FORMULAS @LIZZIEPIKA
18. FORMULAS @LIZZIEPIKA
19. @LIZZIEPIKA DATA
20. @LIZZIEPIKA WHERE I GET MY DATA https://github.com/awesomedata/ awesome-public-datasets
21. @LIZZIEPIKA VIRGINIA, USA SAO PAULO, BRAZIL DUBLIN, IRELAND SINGAPORE SYDNEY, AUSTRALIA TOKYO, JAPAN
22. - DEVELOPER EVANGELIST AT TWILIO - LIKES [PEOPLE, PYTHON, AND © 2017 TWILIO, INC. ALL RIGHTS RESERVED.
23. - DEVELOPER EVANGELIST AT TWILIO - LIKES [PEOPLE, PYTHON, AND © 2017 TWILIO, INC. ALL RIGHTS RESERVED.
24. @LIZZIEPIKA LIVE CODE
25. Lorem ipsum Lorem ipsum Lorem ipsum Main content and supporting text INTRO TO TWILIO •APIs for developers building the future of communications •SMS, Voice, Video, Security, Flex, etc. •Python, Swift, Java, C#, etc. @LIZZIEPIKA
26. Lorem ipsum Lorem ipsum Lorem ipsum Main content and supporting text @LIZZIEPIKA FLASK • Popular Python micro web framework
27. @LIZZIEPIKA
28. (240) 219-8265 “Lebron james stephen curry pts” @LIZZIEPIKA
29. -created workbook, worksheet -Set title, tab color -Copy of sheet -Written to new and existing sheets -Overwritten cells -Written images to sheet -Used formulas -Parsed NBA stats @LIZZIEPIKA Overview
30. THANK YOU! @LIZZIEPIKA. LSIEGLE@TWILIO.COM - HTTPS://OPENPYXL.READTHEDOCS.IO - HTTPS://GITHUB.COM/ELIZABETHSIEGLE/ NBA-STATS-TWILIO-SMS-BOT