Write a python program to: Find all rows with a title of "Limitless" Find all rows with a director of "Robert Rodrigues" and a type of "Movie" Find all rows with either a date_added of "2019-07-31" or director of "Robert Altman" Find all rows with a director of "Orson Welles","Aditya Kripalani" or "Sam Raimi". Find all rows that have a date_added value between May 1, 2019 and June 1,2019 Drop all rows with a NaN value in the director column. Identify all days when only one movie was added to Netflix catalog. Note: the question come with a csv file that contains all the necessary data. the csv file looks like this

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Write a python program to:

Find all rows with a title of "Limitless"

Find all rows with a director of "Robert Rodrigues" and a type of "Movie"

Find all rows with either a date_added of "2019-07-31" or director of "Robert Altman"

Find all rows with a director of "Orson Welles","Aditya Kripalani" or "Sam Raimi".

Find all rows that have a date_added value between May 1, 2019 and June 1,2019

Drop all rows with a NaN value in the director column.

Identify all days when only one movie was added to Netflix catalog.

Note: the question come with a csv file that contains all the necessary data. the csv file looks like this

 

1 title, director, date_added, type
2 Alias Grace,,3-Nov-17, TV Show
A Patch of Fog, Michael Lennox,15-Apr-17, Movie
4 Lunatics,,19-Apr-19, TV Show
5 Uriyadi 2, Vijay Kumar,2-Aug-19, Movie
Shrek the Musical, Jason Moore, 29-Dec-13, Movie
7 Schubert In Love, Lars Büchel, 1-Mar-18, Movie
We Have Always Lived in the Castle, Stacie Passon, 14-Sep-19, Movie
9 7SEEDS,, 28-Jun-19, TV Show
10 Voyeur, Myles Kane,1-Dec-17, Movie
11 You, Lee Toland Krieger, 26-Dec-18, TV Show
Hasta los dientes, Alberto Arnaut Estrada, 13-Aug-19, Movie
LEGO House - Home of the Brick, Anders Falck, 15-Jun-18, Movie
15
14 Without Gorky, Cosima Spender, 31-May-17, Movie
Chalay Thay Saath, Umer Adil,15-May-18, Movie
Ocean's Thirteen, Steven Soderbergh, 1-Oct-19, Movie
17 Loaded,,1-Apr-18, TV Show
18 The Family Court,,1-Nov-17, TV Show
19 Lincoln, Steven Spielberg, 21-Feb-18, Movie
The Rugrats Movie, Igor Kovalyov, 1-Oct-19, Movie
21 DJ Cinderella, Bruno Garotti, 14-Jun-19, Movie
22 "Game Over, Man!", Kyle Newacheck, 23-Mar-18, Movie
A Dangerous Woman, Stephen Gyllenhaal, 1-Apr-18, Movie
Pareeth Pandaari, Gafoor Y. Elliyaas, 1-Jul-18, Movie
25 Enemy, Denis Villeneuve, 15-Jul-18, Movie
24
26 68 Kill, Trent Haaga, 1-Sep-19, Movie
27 After Life,,8-Mar-19, TV Show
28 Miss Dynamite,, 5-May-18, TV Show
29 Dollar,, 8-Aug-19, TV Show
30 Easy Fortune Happy Life,,1-Sep-16, TV Show
31 Chopsticks, Sachin Yardi, 31-May-19, Movie
32 Anjelah Johnson: Not Fancy, Jay Karas, 2-Oct-15, Movie
33 Good Girls,,1-Jan-19, TV Show
Transcribed Image Text:1 title, director, date_added, type 2 Alias Grace,,3-Nov-17, TV Show A Patch of Fog, Michael Lennox,15-Apr-17, Movie 4 Lunatics,,19-Apr-19, TV Show 5 Uriyadi 2, Vijay Kumar,2-Aug-19, Movie Shrek the Musical, Jason Moore, 29-Dec-13, Movie 7 Schubert In Love, Lars Büchel, 1-Mar-18, Movie We Have Always Lived in the Castle, Stacie Passon, 14-Sep-19, Movie 9 7SEEDS,, 28-Jun-19, TV Show 10 Voyeur, Myles Kane,1-Dec-17, Movie 11 You, Lee Toland Krieger, 26-Dec-18, TV Show Hasta los dientes, Alberto Arnaut Estrada, 13-Aug-19, Movie LEGO House - Home of the Brick, Anders Falck, 15-Jun-18, Movie 15 14 Without Gorky, Cosima Spender, 31-May-17, Movie Chalay Thay Saath, Umer Adil,15-May-18, Movie Ocean's Thirteen, Steven Soderbergh, 1-Oct-19, Movie 17 Loaded,,1-Apr-18, TV Show 18 The Family Court,,1-Nov-17, TV Show 19 Lincoln, Steven Spielberg, 21-Feb-18, Movie The Rugrats Movie, Igor Kovalyov, 1-Oct-19, Movie 21 DJ Cinderella, Bruno Garotti, 14-Jun-19, Movie 22 "Game Over, Man!", Kyle Newacheck, 23-Mar-18, Movie A Dangerous Woman, Stephen Gyllenhaal, 1-Apr-18, Movie Pareeth Pandaari, Gafoor Y. Elliyaas, 1-Jul-18, Movie 25 Enemy, Denis Villeneuve, 15-Jul-18, Movie 24 26 68 Kill, Trent Haaga, 1-Sep-19, Movie 27 After Life,,8-Mar-19, TV Show 28 Miss Dynamite,, 5-May-18, TV Show 29 Dollar,, 8-Aug-19, TV Show 30 Easy Fortune Happy Life,,1-Sep-16, TV Show 31 Chopsticks, Sachin Yardi, 31-May-19, Movie 32 Anjelah Johnson: Not Fancy, Jay Karas, 2-Oct-15, Movie 33 Good Girls,,1-Jan-19, TV Show
Expert Solution
steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Array
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education