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

icon
Related questions
Question

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
Transcribed Image Text: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
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
Transcribed Image Text: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
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Similar questions