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

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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.