Data Insights through GenAI
Some of you already might be using GenAI for your data analytics. In this article I just wanted to walk you through a very simple but powerful approach. To demonstrate the approach, I will use hotel booking data available here (more than 100k data points/rows):
By giving the appropriate prompt to GenAI, we get a Python program which gives very valuable insights to us, the program that was generated is available here:
When we run this code we get the following output
This result tells us that if booking has an arrival day of Sunday or Tuesday, it has a 20% less chance of being cancelled as compared to an arrival day of Thursday or Friday. We can create some visualisation to make the insight more apparent.
Would you like to know the prompt that we gave to GenAI to get the above output (through the Python program)?
?