Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q 3 : Using the feature video _ views _ for _ the _ last _ 3 0 _ days , a . Do you

Q3: Using the feature video_views_for_the_last_30_days,
a. Do you think field values are complete? and why?
b. Do you think field values are consistent? and why?
c. Propose two methods to fix the nan values? Provide at least one reason for why you
have chosen each fix.
Note: nan means missing values or do not exist at all.
video_views_for_the_last_30_days
2258000000
12
1348000000
1975000000
1824000000
nan
731674000
39184000
48947000
580574000
803613000
714614000
nan
498930000
18
1657000000
1
168290000
16
176326000
598173000
1707000000
473387000
447223000
420292000
254961000
1188000000
10
141200000
114668000
422634000
611828000
232025000
461148000
259310000
260193000
112100000
512093000
159
202720000
815949000
528392000
160216000
266747000
66388000
146862000
306540000
232744000
440
314505000
94
1
33842000
233988000
130359000
48032000
1337000000
nan
134242000
26683000
176629000
22
4
353412000
303780000
1149000000
159757000
670459000
53202000
182926000
180942000
136745000
98775000
nan
5773000
5
247731000
2
78688000
58362000
560756000
264108000
130461000
1635000000
45638000
1589000
814756000
6348
21804000
415914000
205594000
244093000
321026000
140754000
49861000
267060000
251449000
175243000
152825000
131462000
318702000
21103000
nan
169242000
32
302071000
533793000
290847000
331474000
53
127329000
238613000
335307000
nan
86
101357000
128696000
547141000
179903000
39094000
403508000
210955000
nan
115792000
272255000
61307000
24736000
55654000
136084000
157101000
127498000
20263000
1463000000
329861000
373828000
1
465647000
56534000
44505000
1667000000
233402000
798510000
31455000
109125000
112648000
153280000
27022000
312099000
105126000
nan
244925000
3589
22511000
190679000
188837000
102998000
31822000
461472000
157908000
21440000
45822000
122926000
22724000
137099000
nan
116434000
nan
100040000
107525000
40425000
88749000
26171000
81884000
1
15
180519000
303100000
12143000
6080

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Database And Knowledge Base Systems

Authors: S Krishna

1st Edition

9810206208, 978-9810206208

More Books

Students also viewed these Databases questions