
Explore how to set up PyCharm for Python development, configure the interpreter, create projects and folders, write and run .py files, and use basic editing shortcuts.
Explore customizing PyCharm's appearance with color schemes such as dark and Dracula to improve clarity. Adjust editor font size and line height in settings to tailor code readability for learning.
All files have py extension as you know. Please install pycharm and then use them. All modules are compressed in zipped. So, you need to download and then extract the files using winzip
Learn Python variable naming rules, including no spaces, no starting with a number, and allowed underscores. Compare camel case, snake case, and pascal case, and avoid reserved words.
Explore constructors and casting in Python to convert data types using int, float, and str; learn how to transform strings and decimals, inspect types, and format prints.
Explore the Python print function, detailing end and separator parameters, how default spaces and newlines affect multi-line output, and how to format prints with custom separators and line breaks.
Explore strings in Python by indexing and slicing: access characters by zero-based indices, use negative indices for the last characters, and practice slicing to retrieve middle or any position.
Learn Python string slicing: start from zero, use up to as the end (exclusive), and optionally skip characters to extract every nth substring.
Master reversing strings in Python by slicing from the end with negative indices, learn how bounds exclude or include characters, and practice with examples and reverse-order logic.
Master the split method in Python by setting a delimiter to divide strings into a list, as spaces or commas create separate items, with basic list concepts and slicing ideas.
Explore python's arithmetic operators, including plus, minus, multiply, divide, exponentiation with double star, modulus and floor division, with hands-on examples that illustrate remainders.
Explore Python assignment operators and their shortcuts, such as x += 1 and x *= 4, to update values in loops and arithmetic, including modulus and exponent operations.
Explore Python comparison operators, including equals, greater than, less than, and their combinations. Learn that double equals compares, while single equals assigns, and not equals uses exclamation point and equals.
Explore logical operators in Python, including and, or, and not, to combine multiple conditions in if statements. Learn how case sensitivity affects comparisons and how not reverses true/false results.
Explore writing if conditions in Python, using colons and indentation to handle true and false paths. See how all subjects have greater than 70 yield a pass, otherwise fail.
Learn to build a number guessing game in python using if conditions, user input converted to int, with up to three attempts, loops, and a range from 1 to 10.
Explore how to use if and elif in Python to handle multiple conditions, including score ranges for pass, wait, re-attempt, and fail, with clear indentation rules.
Explore how indentation defines if blocks and how elif and else control flow, contrasting single-branch if-elif with separate if blocks, using score examples to show execution.
Explore nested ifs in Python for data analysis by building an age-based decision flow that distinguishes graduate and postgraduate candidates and assigns executive level job paths.
Learn python for loops using range, start and end values, and step sizes to print sequences; note end exclusivity, indentation, and if statements inside loops.
Build a Python number guessing game using loops, three attempts, and 0 to 10 range. Use break to exit early on a guess and show win or lose messages.
Explore Python while loops, the do‑while concept, and conditional flow; learn to control execution with conditions, increments, breaks, and prints.
Learn to implement nested loops in Python, including outer and inner loops with range, and master indentation to ensure correct execution.
define and manipulate lists in python as a data type for multiple values, using square brackets with text or numeric items, and apply indexing and slicing.
Change values in lists by assigning new elements using indices and slices, including zero-based and negative indices, to replace single items or multiple elements.
Learn to insert values into a Python list using the insert method by index, see how original values remain, and print the updated list.
Learn how the append method adds items to the end of a list, unlike insert which targets a specific position, and how Python errors reveal the one-argument requirement.
Learn to remove and delete list items in Python using remove, pop, del, and clear, access methods with the dot operator, and use append or insert to add data.
Explore practical use of for loops on lists, including iterating with range, list length, and indexing. Learn how to access values, apply if conditions, and perform calculations on data.
Run a Python project that checks each number in a list for even or odd status by remainder when divided by two, iterating with a loop and printing results.
Learn to filter names by score from two aligned lists using a for loop, selecting scores above 70 and building a resulting name list for data analysis.
Learn how to use the in and not in operators in Python for membership tests in strings and lists, with examples like 'a' in 'mango' and 20 in score.
Find all triplets in a list whose three numbers sum to one using Python loops and range. Build a dynamic, safe solution that appends valid triplets and avoids index errors.
Use a simple Python loop to compare medal counts, track the highest value, and identify the corresponding sport.
Learn how to write Python if statements in one line, with or without an else block, to control output based on a condition.
Sort Python lists by characters alphabetically and numbers by value using sort; control ascending or descending with reverse, and achieve case-insensitive sorting by converting to lowercase.
Learn to reverse a list, copy a list, and join lists to combine sports and medals. Build a new list by filtering with conditions and appending items using loops.
Learn to replace multiple loops with a single loop using the zip function, merging parallel lists like sports and medals and applying conditional filters in one pass.
Learn how to delete and loop through a tuple by converting to a list, removing items, and converting back, while using for loops, range, and the length function.
Discover index and count methods on tuples and lists to locate the position of a value like Python and count its occurrences, with dynamic indexing from a chosen start.
Learn to handle genuine runtime errors in Python with try and except, preventing division by zero crashes and using graceful fallbacks like alternative calculations and informative messages.
Compare the similarities and differences between lists and tuples, including syntax with parentheses for tuples and square brackets for lists, mutability (mutable vs immutable), indexing, slicing, and type conversion.
Learn how to modify tuple values by converting to a list, updating, and converting back to a tuple, and how to add elements using temporary lists.
Create and call user defined functions in Python to perform calculations, pass parameters, handle arguments, and use if-else logic for correct subtraction and addition results.
Create a python function name_output that formats a user-entered name. If longer than ten characters, output last name followed by first name; otherwise keep first name then last.
Explore function basics in python, including parameters and arguments, default arguments, positional versus keyword arguments, and how missing or extra arguments trigger errors, with practical examples.
Use a star argument to accept any number of function inputs, collect them as a tuple, and process or sum the values dynamically.
Learn to use Python's built-in random module, import random, and apply random.choice to build a lottery-style guessing game with two attempts, showcasing practical randomness in data analysis.
Section 1 – Python Programming Fundamentals
We begin with the fundamentals of Python and gradually build a strong programming foundation.
You will learn:
How to work with Python in PyCharm and understand how Python code is executed.
Variables, data types, and operators, including arithmetic, comparison, logical, in, and not in operators.
IF statements, nested IF statements, and indentation.
For loops and While loops and how to combine loops with conditions.
How to understand Python errors and error messages and use them to troubleshoot your code.
How to create and use functions, including parameters, variable scope, and Local and Global variables.
Lists, Tuples, and Strings in detail, including their important methods and practical use.
Error handling and how to handle exceptions in your programs.
How to use Python's Random module and import modules and functions.
The Print function and useful parameters such as sep and end.
F-Strings and modern string formatting.
You will also build practical projects along the way, including:
Guess the Number Game
Guess the Number Game with multiple attempts
Odd and Even Number projects
Working with multiple lists to analyze data
Other hands-on programming exercises
The goal of this section is to make you comfortable with Python before moving into Data Analytics and Excel automation.
Section 2 – Data Analysis with Pandas
Once you have a solid Python foundation, we move into real-world data analysis using Pandas.
You will learn how to work with Excel, CSV, and text files and perform common data preparation and analysis tasks.
Topics include:
Understanding Pandas and its role in Data Analytics.
Understanding PIP and installing Python libraries.
Reading Excel, CSV, and text files from different locations.
Working with Excel workbooks and specific worksheets.
Renaming and managing column names and headers.
Selecting Top and Bottom records.
Understanding the inplace parameter.
Adding, modifying, and removing columns.
Removing blank rows and columns.
Filtering data using different conditions.
Understanding Set Index.
Selecting data using loc and iloc.
Performing VLOOKUP-style operations using Merge.
Combining data from multiple sources using Concat.
Identifying and removing duplicate records.
Using For Loops with data.
Performing data type conversions.
Analyzing data using Group By.
Creating Pivot Reports using Pandas.
Exporting and working with analyzed data.
You will also work on practical projects based on real-world data so that you can apply the concepts instead of simply learning them theoretically.
Part 3 – Excel Automation with Python
Now we take Python and Pandas a step further by using them to automate Excel and repetitive data management tasks.
You will learn how to:
Work with existing Excel workbooks using Python.
Create new Excel workbooks and save them programmatically.
Work with worksheets, ranges, and cells.
Read, modify, and update existing Excel data.
Apply filters and multiple criteria.
Create and work with Pivot Tables.
Add calculations such as percentages to Pivot Tables.
Modify existing Excel tables and data programmatically.
Create and manage worksheets.
Add, remove, and rearrange worksheets.
Use Python to copy and paste data between spreadsheets.
Accumulate data from multiple Excel workbooks.
Work with folders containing hundreds or thousands of Excel files.
Loop through multiple Excel and text files automatically.
Perform VLOOKUP-style operations across large numbers of files.
Explore different approaches to performing lookups using Python.
Understand the Glob module and use it to find and process files automatically.
Use the OS library to work with files, folders, and file paths.