Gemini Data Science Agent
Wouldn't be great to have code and natural language in one place? Wouldn't it be interesting if AI created an initial data analysis plan that you can modify? Enter Gemini Data Science Agent. Before, Gemini was part of Google Colab, so it functioned to help you with coding errors, etc. If you use Google you have access to the free coding notebook. Instead of uploading a dataset to the notebook, you upload it to Gemini in the lower right. Ask it to analyze the data and it designs a basic plan how to explore and visualize your data. You can agree with the plan and select the "execute plan" button or your can add more steps. Once the plan begins you are likely to see descriptive statistics, correlations, imputation and many other logical starting steps to prepare and analyze your data. Please see the blog that I created on this topic.
Video #1 "World Data"
Gemini Embedded in Google Sheets
Google Sheets is a convenient spreadsheet program that is now enhanced by Gemini AI. If you subscribe to Google Workspace, it will automatically be added to Google Sheets. My experience so far is that it does a good job but is inconsistent in the sense that the same command may elicit different results. This is when you can ask Gemini to make changes if something is not right. For example, in one of three runs, it gave the option to copy Python code. For this section, I will ask Gemini the same question three times and see if the answers are similar. For video #2, the initial query worked well, but for the second two, they timed out. Insight and patience are necessary along with an intermediate understanding of data science so you can ask great questions and understand when the GenAI makes a mistake. The creation of a classification and regression model was flawless. When I asked it to analyze longitudinal data from a WHO mortality dataset, it repeatedly said it was unable to analyze, unlike Vizly, which did not hesitate.