Prompt Engineering for Data: Leveraging Prompts for Filtering & Grouping Data

Prompt engineering, data science    |    Intermediate
  • 14 videos | 1h 49m 14s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Data manipulation involves getting your data in the right format to generate further insights. Prompt engineering allows you to specify your problem statements in natural language and generate code to meet your needs. You will begin this course by applying filters to your DataFrames in pandas. You will use logical and comparison operators to specify filter predicates and filter based on datetime data. Next, you will group and aggregate your DataFrames. You will use prompt engineering to explain your grouping and aggregation requirements and tweak generated code to tailor your solutions. Additionally, you will learn about the split-apply-combine method, a step-by-step technique for grouping and aggregation. You will then tackle data cleaning. You will remove rows with duplicate records and deal with missing values and other inaccuracies in your data. Finally, you will explore the use of pivot tables, which help rearrange and reshape data into a format more suitable for analysis.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Perform filtering by column headers and row labels
    Perform filtering and querying
    Execute complex queries
    Perform filtering with dates and strings
    Perform simple aggregations
    Perform groupby and aggregations
  • Perform multi-column groupby
    Remove duplicate records
    Clean categorical data
    View and fill missing values
    Create pivot tables
    Reshape data using pivot tables
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 13s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 6m 15s
    In this video, find out how to perform filtering by column headers and row labels. FREE ACCESS
  • Locked
    3.  Performing Filtering and Querying on Data
    10m 25s
    During this video, you will learn how to perform filtering and querying. FREE ACCESS
  • Locked
    4.  Executing Complex Queries
    10m 35s
    Discover how to execute complex queries. FREE ACCESS
  • Locked
    5.  Filtering Using Dates and Strings
    5m 44s
    In this video, discover how to perform filtering with dates and strings. FREE ACCESS
  • Locked
    6.  Performing Simple Aggregations
    9m 7s
    In this video, learn how to perform simple aggregations. FREE ACCESS
  • Locked
    7.  Performing Grouped Aggregations with ChatGPT's Help
    10m 41s
    Find out how to perform groupby and aggregations. FREE ACCESS
  • Locked
    8.  Performing Multi-column Grouping and Split-Apply-Combine
    8m 23s
    Discover how to perform multi-column groupby. FREE ACCESS
  • Locked
    9.  Using Prompts to Identify and Remove Duplicates
    7m
    In this video, you will learn how to remove duplicate records. FREE ACCESS
  • Locked
    10.  Cleaning Categorical Data
    8m 20s
    During this video, discover how to clean categorical data. FREE ACCESS
  • Locked
    11.  Using Prompt Engineering to Deal with Missing Values
    11m 52s
    Learn how to view and fill missing values. FREE ACCESS
  • Locked
    12.  Working with Pivots and Pivot Tables
    8m 50s
    In this video, find out how to create pivot tables. FREE ACCESS
  • Locked
    13.  Reshaping and Aggregating Data Using Pivot Tables
    7m 11s
    During this video, you will learn how to reshape data using pivot tables. FREE ACCESS
  • Locked
    14.  Course Summary
    2m 38s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Audiobook Fundamentals of Data Engineering: Plan and Build Robust Data Systems
Course CompTIA Data+: Data Acquisition & Cleansing
Rating 4.6 of 13 users Rating 4.6 of 13 users (13)
Course Querying SQL Databases: Using Generative AI Tools to Filter & Group Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting started in Excel 365
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Course Leveraging Prompts for Python Classes, Scripts, & Data Analysis
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Working with tables in Excel 365
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)