118 docs tagged with "Python"

openpyxl, python-docx, python-pptx, selenium summary

Learn the concept and usage of the dictionary data structure consisting of keys and values

How to create a text box and add text to slides

How to add or remove values to/from a list

How to adjust the width and height of Excel cells

Automate the analysis of unit price, sales volume, and revenue data by month and product using Pandas

Learn how to read sales data from a CSV file for each customer and send it automatically via email.

Learn how to automatically send customized sales reports to clients via email.

How to automate repetitive Excel tasks using Python and openpyxl

Introduction to Web Automation with Selenium

Learn how to handle data easily with the Pandas package.

Write a program to create a simple table using the python-docx library.

How to format text added to slides

A fundamental course on how to improve Python code and write effective prompts

How to define and use functions in Python

Write a Python function that takes two numbers and an arithmetic operation input and performs the desired operation

Write a program to implement a binary search algorithm using Python.

Write a function to convert temperatures between Celsius (C) and Fahrenheit (F)

Write a program using a Python function that returns ten times the given number.

A coding quiz using Python's list sorting method, sort() function

Write a program that returns the sum of even numbers from a given list.

Write a program to extract specific data from a web page using requests and BeautifulSoup.

How to collect data from the web using the Python requests package

Using and and or for compound conditions

Parameters, Arguments, and Return Values in a Function

9

Handling complex logic using nested conditionals

Learn about the concept and usage of variables

How to use the while loop in Python to control repeated tasks

How to convert data types in Python and why it's necessary

Practical web crawling exercise using learned Selenium knowledge

Introduction to document automation with the basics and installation of Python-docx

How to insert tables in slides, merge/split cells, format cells, and add data using python-pptx.

Learn how to create various charts and visualize data on slides using python-pptx

Understanding and utilizing the pass keyword

Explore the concept of data structures, their importance in programming, and some simple data structure examples.

Understanding data types and their significance in Python programming

Understanding constructors, destructors, and methods in Python classes

Learn about the basic concept of linked lists and how to implement them in Python.

Methods to input data into Excel using sheet.cell, and how to automate data entry using loops

Key methods and techniques for handling dictionaries in Python.

Understanding the structure of email messages and composing emails using the MIME format

Learn how to manage and reuse code more effectively in Python by utilizing modules.

The role of escape characters in programming and common examples

Basic CSS knowledge you must know before starting web crawling

Basic HTML knowledge you need to know before starting web crawling

Basic HTTP knowledge you must understand before starting web crawling

Learn the concept of exceptions in programming and how to handle them in Python.

Key methods of Workbook and Sheet objects

Learn how to extend the functionality of a class through inheritance in Python.

How to crawl data from Wikipedia pages using Python

Understanding the concept of the binary search algorithm and its implementation in Python through example code

The meaning and usage of the pass keyword

Applying accounting and currency formats to Excel columns, and adjusting cell width and height

Learn how to format Excel files using the `openpyxl` library in Python.

Introduction to commonly used methods for web automation using Selenium

Solving the inefficiency of repetitive office tasks with Python

Learn how to create simple presentations using the python-pptx library.

Reuse and manage your code efficiently by creating your own modules

Learn how to modify cell values and cell formatting using openpyxl

Learn various ways to read files in Python easily.

Learn how to send a simple email using Python's smtplib

Learn how to automatically send periodic emails using Python.

How to receive user input and display results in Python

Learn how to work with dictionaries in Python.

Examples and explanations of using pandas and openpyxl together

Learn and utilize methods to write data to a file in Python.

Learn about tuples, the immutable lists in Python

How to insert images into slides and adjust their size and position.

How to easily insert Excel data into a slide as a table

Basic explanation of the concept of files, and how to open and close files.

Overview of tools and libraries for automating office programs using Python

How to crawl content dynamically generated by JavaScript on web pages

Easy extraction of web data using BeautifulSoup methods

Explanation of keyword arguments and variable scope to understand advanced function concepts

How to handle complex iterative tasks using nested loops in Python

Learn the basic concept of hash tables and how to implement a simple version in Python.

Learn about Python's basic data type List

Learn how to handle data easily with the Pandas package.

Concepts and usage of arithmetic, comparison, and logical operators

Use cases and key methods of Pandas and openpyxl

Learn how to parse HTML data and extract necessary information using the Python BeautifulSoup package

Learn the basic concepts of a stack and how to implement it in Python.

Hands-on examples and use cases for web automation using Selenium

Crafting prompts for efficient Python code generation using AI

Outputting the value by adding 5 to a given number

Learn how to easily handle data using the Pandas package.

Using regular expressions in Python to filter data while web crawling

Structure and use cases of the for loop in Python

Utilizing tuple unpacking and list conversion

Understanding the meaning of keywords in programming and key Python keywords

Learn how to read data from an Excel file using Python's openpyxl and automatically send it via email.

3

How to convert web crawling results to CSV and send as an email attachment

How to Send an Email with Attachments Using Python

Learn how to crawl weather information using Python's Selenium and send it periodically via email.

Learn how to use lambda functions in Python and their usefulness.

Understanding the role and usage of break and continue in Python loops

Learn frequently used operations on lists

Learn the basic concepts of queues and how to implement them in Python.

Summarize the key points and usage of email automation.

How to control code flow using conditional statements

The role and usage of break and continue in Python for controlling loops

Basics and applications of comparison operators used with conditional statements

How to enhance code efficiency with loops in Python

Efficient methods to process lists with loops

Learn how to use percent formatting, f-string, and other methods to print values in Python

Learn how to automatically generate charts and graphs in Excel files using `openpyxl` in Python.

Learn the concept of packages in programming and how to use them in Python.

How to call functions in Python and what it means

Learn the basic concepts of tree structure and a simple implementation in Python.

The concept of algorithms and their importance in programming

Understanding Python's indentation for clear code structure

Learn the basic concepts of Object-Oriented Programming in Python.

An introduction to basic programming concepts and terminology

An introductory guide to understanding the history and popularity of Python.

How to automate repetitive email tasks using Python

Introduction to detecting and fixing errors in Python code using AI tools