day. If there is no # price data on a day, we know that price did not change on that day, so its takes the previous value. For example, for # game 730 (Counter-Strike: Global Offensive). The price was
We need to clean the price change data to get daily prices. For a game-date combination, if the game_price_changes # data has an observation on that day, the $price variable in that data measures the price on that day. If there is no # price data on a day, we know that price did not change on that day, so its takes the previous value. For example, for # game 730 (Counter-Strike: Global Offensive). The price was changed to $9.99 on 2012-11-01. Then it was changed again # to $11.24 on 2012-11-22. This means that before the change on 2012-11-22, the price stayed at $9.99. # By the end of this step, you should have a price data at the level of game-date. There should be no gap in dates unless # for specific reasons that lead to missing data. You should then be able to merge the players data with the price data.
![1
Ν
2
3
4
5
6
Ο
7
0
8
9
10
11
12
13
app_id
price_change_date
10 2012-11-22
10 2012-11-23
10 2012-11-24
10 2012-11-25
10 2012-11-26
10 2012-11-27
10 2012-11-28
10
2012-11-29
10 2012-11-30
10 2012-12-01
10 2012-12-02
10 2012-12-03
10 2012-12-04
10 2012-12-05
price
4.99
ΝΑ
ΝΑ
ΝΑ
ΝΑ
2.49
ΝΑ
ΝΑ
ΝΑ
ΝΑ
ΝΑ
ΝΑ
ΝΑ
ΝΑ
14
NA
15
10 2012-12-06
Showing 1 to 15 of 6,158,589 entries, 4 total columns
discount
50
ΝΑ
ΝΑ
ΝΑ
ΝΑ
75
ΝΑ
ΝΑ
ΝΑ
ΝΑ
ΝΑ
ΝΑ
ΝΑ
ΝΑ
NA](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff7e5cd48-1764-4e35-a037-3f24ff15348c%2F0bf8ed4c-6724-4124-afe5-ab19b87cf0d0%2F10nwrm8_processed.png&w=3840&q=75)
![1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
app_id
date
730 2011-11-30
730 2012-02-28
730
2012-03-09
730 2012-03-16
730
2012-03-17
730
2012-03-18
730
2012-03-19
730
2012-03-20
730
2012-03-21
730
2012-03-22
730 2012-03-23
730 2012-03-24
730 2012-03-25
730 2012-03-26
730 2012-03-27
player_count
680
204
460
728
678
570
448
225
421
653
1035
1081
848
700
572](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Ff7e5cd48-1764-4e35-a037-3f24ff15348c%2F0bf8ed4c-6724-4124-afe5-ab19b87cf0d0%2Frmgnxd8_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)