104 - Pivot tables, spreadsheets and timezones - Beginners' Python and Machine Learning
A Google colab notebook is provided https://colab.research.google.com/drive/1E2UpcfeixraUxQG3PWUyhpIQsKPfcWId This session will demonstrate pivoting and unpivoting datasets using pandas. We will read and write excel spreadsheets from pandas including how to format the data. The default library xlrd has dropped support for xlsx files, so this video will show you alternatives. Every programmer's worst nightmare is timezones and daylight savings so we will be exploring some good programming practices to deal with these issues. This session will use Google colab so you don't even need Python installed on your computer to follow along. There is a slackspace for sharing data and chatting during the streaming event at beginnerspython.slack.com - please email skypyprojectatgmaildotcom for an invitation to join the space. Register at https://www.meetup.com/Beginners-Python-Machine-Learning/events/277479287/
A Google colab notebook is provided https://colab.research.google.com/drive/1E2UpcfeixraUxQG3PWUyhpIQsKPfcWId This session will demonstrate pivoting and unpivoting datasets using pandas. We will read and write excel spreadsheets from pandas including how to format the data. The default library xlrd has dropped support for xlsx files, so this video will show you alternatives. Every programmer's worst nightmare is timezones and daylight savings so we will be exploring some good programming practices to deal with these issues. This session will use Google colab so you don't even need Python installed on your computer to follow along. There is a slackspace for sharing data and chatting during the streaming event at beginnerspython.slack.com - please email skypyprojectatgmaildotcom for an invitation to join the space. Register at https://www.meetup.com/Beginners-Python-Machine-Learning/events/277479287/