ETL Transform application of validation rules and transformation
26 February 2024ETL Load Reporting and loading to other systems
26 February 2024At the upload stage, we can also create automatic reports and embed visualizations and any data that a manager or specialist waiting for the results of the validation will need to receive. To create Python code that generates a PDF file with a histogram and a description of the data analysis results, we only need to formulate a query to ChatGPT.
❏ Text request to ChatGPT:
Write code to create a PDF with a histogram and description of the results of the data validation that was obtained above and write a warning in the form of text that some categories did not pass the validation and that you need to complete the missing data. ⏎
➤ ChatGPT Answer:
A code of a dozen lines of code generates a PDF document that contains a histogram with validation data and text with results and recommendations
Automatically written code using ChatGPT instantly creates a document with just 20 lines of code, with visualization in the form of an attribute histogram showing the amount of data that passed and failed the check, as well as with the addition of a text block with a brief description of the results and recommendations for further action.
