Python Programming Challenge: Manage A Movie Theatre with Real Life Data!

Python Programming challenge to learn Python in a practical manner with an interesting app using database, password validator, csv file and database.

Duration: 1 Day

Location:  online instructor-led  or in our London classroom

Download: Anaconda.com

Study level and Pre-requisites: Not quite beginners level, i.e. you can print "hello world", add 2 numbers, do an if-else, and print 1,2,3

Certificate: PCWorkshops Python Programmer Certificate

COURSE OUTLINE

Session 1: Essentials (Revision)

• Data Types, Variables: Characters, Strings, Boolean, Numbers. Working with variables and its scope. Type conversion and casting.
• Operators and Expressions: Arithmetic operators; Assignment operator; Logical operators; Increment and decrement operators; Logical and realtional oprators.
• Decision Making: If statement; If - else statement; If- elif - else statement; Nested if - else.
• Using Loops: The while, while-else; for loop; Enhanced for loop; break, continue;

CHALLENGE:

• Create a password validator

Hours 2 and 3: Object Oriented programming (OOP)

• Creating and using Functions. Return values; parameters;
• Create a class, object and class a method. Constructors. Inheritance. Polymorphism.

Hour 4:

• Lists. Connect to a database, create tables.

CHALLENGE

• Create a login and add users to the database with valid passwords.

Hour 5 and 6: Data Analytics with Pandas Data Frames:

• Pandas for data analytics and data queries.
• Read a csv file into a dataframe.
• How to create dataframes, inspect dataframes, get stats, slice, transform dataframes.
• How to clean data, working with nulls, remove duplicates, unique values, group, query, filter data.
• Analyse the dataframe:
• E.g:
• Which actors earn the most money. Which actors appear often but earn less. Which directors work regularly with the highest earning actors? Whic actor/director combo eran the most money.

 CHALLENGE:

• Create a dataframe with the most lucrative combination of actors and directors and add them to the database.
• Users (movie theatre managers) can login and schedule a movie program for a week in their cinema.

INCLUDED:

• Python Course notes.
• Practical Course exercises, Code Examples, Online Materials.
• After the course, 1 hour 1-1 assistance from the trainer
• Personal attention: Max group size on this is 4.
• PCWorkshops Python Course Certificate on completion.

MORE ABOUT THE ONLINE CLASSROOM

•  Attend from your internet connection
•  Instructor-led, get instant answers to your questions
•  Fully interactive
•  Work clearly explained with demonstrations and examples
•  Practical exercises to be tried out by delegate

WHAT YOU WILL GAIN:

• Skills & knowledge: Python coding knowledge and understanding with good practical application  
• Certification: Internal PCWorkshops Python certificate
• Experience: many exercises during the day to explain and illustrate the topics and give you hands-on experience of implementing the topics, plus examples in the notes that you could try out.

Event Venue & Nearby Stays

Golden Cross House,, Duncannon Street, London, United Kingdom