# Viewing Shared Thread from Rosalina Saige (@catgirl)

## Thread data created from

Let's first read and parse the data from the uploaded JSON Lines file. We can then filter out battles played with "AAGaming" in the past 2 days and create a battle group using those filtered battles.

Let's start by parsing the JSON Lines file.

The error indicates that there's a mismatch between offset-naive and offset-aware datetime objects.

We'll adjust the `time_threshold`

to be offset-aware by including the same timezone info as the parsed `played_time`

.

Let's update the code accordingly.

I have created a battle group with battles involving "AAGaming" in the past 2 days. Here are the details:

Battle Group**Group ID**: 130

Let's proceed by analyzing and visualizing your win rate over the past month, grouped by day. First, we will filter the battles played in the past month, then group them by day and calculate the win rate for each day.

Let's begin by processing the data.

Here is the graph of your win rate over the past month, grouped by day. The win rate as a percentage is plotted on the y-axis, and dates are on the x-axis.

As can be seen from the graph, your win rate has varied day by day, with noticeable peaks and troughs.

Is there anything else you would like to analyze or visualize?

Let's modify the analysis to calculate the win rate over the past year, grouped by month. We'll update the code to filter battles played in the past year, group them by month, and then calculate the win rate for each month.

Let's proceed with this update.

Here is the graph of your win rate over the past year, grouped by month. The win rate as a percentage is plotted on the y-axis, and months are on the x-axis.

The graph provides a clear picture of how your win rate has fluctuated throughout the year, with distinct highs and lows.

Is there anything else you would like to analyze or visualize?

We'll compare your win rates with the three specific weapons: E-liter 4K, Z+F Splat Charger, and Z+F Splatterscope. To do this, we'll filter the battles where you used each weapon and calculate the win rate for each.

Let's proceed by analyzing the data for each weapon.

Here are your win rates with the specified weapons:

**E-liter 4K**: 48.70%**Z+F Splat Charger**: 48.01%**Z+F Splatterscope**: 50.38%

Based on the data, you have the highest win rate with the **Z+F Splatterscope** at 50.38%.

If there's anything else you'd like to explore or analyze, please let me know!

To create a graph that shows your win rates with the specified weapons (E-liter 4K, Z+F Splat Charger, and Z+F Splatterscope) over the past year, grouped by week, we will:

- Filter the battles played in the past year.
- Group the battles by week.
- Calculate the win rate for each weapon for each week.
- Plot the data with each line representing a different weapon.

Let's proceed with this analysis.

Here's the graph of your weekly win rate over the past year for the three specified weapons:

**Red Line**: E-liter 4K**Green Line**: Z+F Splat Charger**Blue Line**: Z+F Splatterscope

The graph shows how your win rates with each weapon have varied week by week over the past year.

If there's anything else you'd like to explore or analyze, please let me know!

Let's update the analysis to exclude weeks where you played fewer than 10 battles with a specific weapon. This will ensure that the displayed win rates are based on a more substantial number of battles.

We'll filter out the weeks with fewer than 10 battles for each weapon before plotting the win rates.

Let's proceed with this update.