Pandas: Generating “Personal” Feedbacks

A short python pandas tutorial about retrieving random value(s) from different sheets in an excel file, in python.

Introduction/Motivation

POV: You are a teacher of a certain course — in this example, a data analytics bootcamp course. You need to give each student “personal” feedbacks based on their performance on the class, for different performance aspects — in this case: Proficiency, Problem-Solving, Project Work, Communication, Collaboration, and Learning. Those are some of the most important quality of a person that works as a Data Analyst. They don’t just need to be able to handle their tasks in python and SQL, but they also need to have a communication skill up to a certain level, for example. This skill is needed to communicate better when they need more details from clients regarding the data source and/or clients’ expectations and needs; or to BI analysts, so they could deliver the insights and key points that they found inside the data as real form of informative story and not just as numbers and diagrams. They also need to have the ability to work not just as a solo analyst that works only in partner with their laptop, but they should also be ready to work in a team of data analysts, or even in a cross-functional team, which consists of experts in different work functions, such as BI Analyst, Data Pipeline Engineer, Data Scientists, and many more.

To give feedbacks to the students, we will score their performance in those six aspects, using both numerical values as…