Location

Community Services & Continuing Education - Cairo

Objectives

• A majority of data is stored in databases and knowing the necessary tools needed to analyze and clean data directly in databases is indispensable.In this course, you'll learn the fundamentals of the Python programming language, along with programming best practices. You’ll learn to represent and store data using Python data types and variables, and use conditionals and loops to control the flow of your programs. You’ll harness the power of complex data structures like lists, sets, dictionaries, and tuples to store collections of related data. You’ll define and document your own custom functions, write scripts, and handle errors. Lastly, you’ll learn to find and use modules in the Python Standard Library and other third-party libraries.

Outcomes

xplore fundamental programming concepts in Python like logic checks, data structures, and functions through interactive quizzes and practice on your own computer. Learn syntax, debugging techniques and basic problem-solving concepts.

Course Contents

Why Python ProgrammingReceive an overview of what you’ll be learning and doing in the courseUnderstand why you should learn to programming with PythonData Types and OperatorsRepresent data using Python's data types: integers, floats, booleans, strings, lists, tuples, sets, dictionaries, compound data structuresPerform computations and create logical statements using Python’s operators: Arithmetic, Assignment, Comparison, Logical, Membership, IdentityPractice whitespaceData analysis with aggregationsCreating aggregationsCreating grouped aggregationsDealing with missing dataRemoving missing valuesImputing missing values (I)Binning data with CASEUsing CASE statementsCreating several groups with CASECounting and totalsCalculating the totalCounting the number of rowsDatesWhich date function should you use?