In this chapter, we converted a tab-separated and a pipe separated file into SQLite3. We performed a table join to combine ratings with movie genres because we have datasets that involve multiple tables, and sometimes that requires a table join. We performed a table join followed by a GROUP BY in order to study how movie ratings change with the age of the viewer. Finally, we performed KDE on individual movies and compared the two directly, despite the fact that they have different values in each dataset. So, that is the benefit of the kernel density estimator.
United States
Great Britain
India
Germany
France
Canada
Russia
Spain
Brazil
Australia
Singapore
Hungary
Ukraine
Luxembourg
Estonia
Lithuania
South Korea
Turkey
Switzerland
Colombia
Taiwan
Chile
Norway
Ecuador
Indonesia
New Zealand
Cyprus
Denmark
Finland
Poland
Malta
Czechia
Austria
Sweden
Italy
Egypt
Belgium
Portugal
Slovenia
Ireland
Romania
Greece
Argentina
Netherlands
Bulgaria
Latvia
South Africa
Malaysia
Japan
Slovakia
Philippines
Mexico
Thailand