AI Use case: Assess vmstat data using gemini and generate charts and summary of the observation

Objective: Assess vmstat data using gemini and generate charts and summary of the observation.

CPU Loader:

for i in 1; do while : ; do : ; done & done

Ask AI to process first the raw vmstat output: It mostly will fail

Prompt for raw data processing:

Can you please process the attached vmstat file and generate a vertically sliced metrics chart and summary?

Failed!!!!

A) preprocess in notepad++

1) Replace all whitespaces to , in notepad++

find: \x20+ 

repace: ,

2)First character to become ,:

find: ^(\d+)\,

replace: ,$1,

3) Remove the repeated vmstat headers
find and bookmark such lines 
delete all bookmarked lines

Ask AI now to process the preprocessed output file and generate graph. It will succeed
prompt: Can you please process the attached vmstat csv file and generate a vertically sliced metrics chart and summary?

Outputs:

First version:

Revisions:

This should help!
Thanks