Description

In this comprehensive course, you’ll learn essential skills for working with various types of files in Python. From text files to Excel spreadsheets, you’ll gain the knowledge needed to manipulate data effectively.

Key Topics:

• Text File Handling: Understand how to read from and write to text files, enabling you to store and retrieve data efficiently.
• CSV File Operations: Learn how to handle CSV files, a common format for storing tabular data, and perform tasks such as parsing and writing CSV files.
• JSON File Manipulation: Explore techniques for working with JSON files, a popular format for storing structured data, and learn how to serialize and deserialize JSON objects.
• Excel File Management: Dive into Excel file handling using libraries like Pandas, allowing you to extract, modify, and analyze data stored in Excel spreadsheets.
• OS Module Automation: Discover the power of the OS module to automate file-related tasks, such as directory navigation, file deletion, and more.
• Exception Handling: Learn how to handle exceptions gracefully to ensure your programs can recover from errors and continue execution.
• Document Search: Develop skills to search text documents programmatically, enabling you to locate specific words or phrases within files.
• Data Formatting: Master techniques for formatting data according to specific requirements, ensuring consistency and clarity in your output.

By the end of this course, you’ll have the expertise to work confidently with various file formats in Python and automate routine tasks, boosting your productivity as a Python developer.

• 1. 01 Work with text files
  • 01 Create And Read A New Text File | Python Interview Question

    6:29

  • 02 Read And Write A Text File With A Loop | Python Interview Question

    7:14

  • 03 Copy Contents Of A File | Python Interview Question

    4:05

• 2. 02 Work with csv files
  • 01 Print Csv Contents | Python for Automation

    4:26

  • 02 Print Csv As List | Python for Automation

    3:01

  • 03 Create A Csv File | Python for Automation

    3:36

• 3. 03 Work with json files
  • 01 Read And Write To A Json File | Python for Automation

    3:15

• 4. 04 Work with Excel files
  • 01 Inspect Excel Sheets | Python for Automation

    5:08

  • 02 Merge Excel Files | Python for Automation

    13:45

  • 03 Get Value From Cell In Excel Sheet | Python for Automation

    7:13

  • 04 Display Entire Excel Sheet Contents | Python for Automation

    3:49

  • 05 Create A New Excel File With Values | Python for Automation

    2:35

• 5. 05 Automate files with OS Module
  • 01 Find A File By Name | Python for Automation

    3:18

  • 02 Check If File Or Directory Path Exists | Python for Automation

    3:04

  • 03 List All Files And Directories At A Path | Python for Automation

    2:52

  • 04 Find All Files Of Given Type | Python for Automation

    2:56

  • 05 Delete Old Files With Datetime Module | Python for Automation

    6:25

  • 06 Bulk Rename Files | Python for Automation

    4:54

• 6. 06 Work with exceptions
  • 01 Handle Exceptions | Python for Automation

    4:21

  • 02 Use Asserts | Python for Automation

    3:24

• 7. 07 Search documents for words
  • 01 Search TXT File | Python for Automation

    4:14

  • 02 Search CSV File

    2:13

• 8. 08 Format data
  • 01 Format Data Into Table | Python for Automation

    6:31

  • 02 Visualize Product Sales Per Quarter | Python for Automation

    9:38