You are a data analyst working for a tech company closely monitoring the AI tools market. You want to understand the evolving popularity of three major AI tools, ChatGPT, Gemini, and Microsoft Copilot, and identify which tool is gaining the most traction and how they compare over time.
You'll work with real-world time series data that captures the global interest in these tools over several weeks. Your goal is to analyze this data, uncover patterns, and provide actionable insights to help your company make informed decisions. This might include determining where to focus marketing efforts, predicting future trends, or identifying potential areas for improvement.
Are you ready to help your company stay ahead of the curve in the competitive AI tools market? Let's get started!
The Data
The Google Trends data is available as a CSV file ai_tools_comparison.csv.
The data contains the number of worldwide searches for chatGpt, Gemini, and Microsoft Copilot over the past 12 months as of September 2024.
import pandas as pd
import matplotlib.pyplot as plt
# Load the data
trends = pd.read_csv('ai_tools_comparison.csv')
# Inspect the data
trends.head()# Start coding here
# Use as many cells as you needtrends.info()trends['week'] = pd.to_datetime(trends['week'])trends.info()trends.set_index('week').plot()most_consistent_tool = 'chatgpt'gpt_dip = 'December 2023'trends.set_index('week').resample('M').mean().idxmax()best_month = 'May'