Question
write a python function that will turn those texts(which are strings) showing the show_id, type, title, director, cast, country, date_added, release_year, listed_in, and description: 80058654,TV
write a python function that will turn those texts(which are strings) showing the show_id, type, title, director, cast, country, date_added, release_year, listed_in, and description:
80058654,TV Show,Transformers: Robots in Disguise,,"Will Friedle, Darren Criss, Constance Zimmer, Khary Payton, Mitchell Whitfield, Stuart Allan, Ted McGinley, Peter Cullen",United States,"September 8, 2018",2016,TV-Y7,1 Season,Kids' TV,"When a prison ship crash unleashes hundreds of Decepticons on Earth, Bumblebee leads a new Autobot force to protect humankind." 70299204,Movie,Kidnapping Mr. Heineken,Daniel Alfredson,"Jim Sturgess, Sam Worthington, Ryan Kwanten, Anthony Hopkins, Mark van Eeuwen, Thomas Cocquerel, Jemima West, David Dencik","Netherlands, Belgium, United Kingdom, United States","September 8, 2017",2015,R,95 min,"Action & Adventure, Dramas, International Movies","When beer magnate Alfred ""Freddy"" Heineken is kidnapped in 1983, his abductors make the largest ransom demand in history." ...
into those lists of sublists: where the show_id are an integer, the director name is separate from the cast, but all the cast members are set into one unique string, also if the director, cast element is empty Set to None and if the country element is empty set to Unknown
the date should be formatted as mm-dd-yyyy( an helper function is provided down for that) set to None if empty
the result should be as follow:
[ [80058654, 'TV Show', 'Transformers: Robots in Disguise', None, 'Will Friedle, Darren Criss, Constance Zimmer, Khary Payton, Mitchell Whitfield, Stuart Allan, Ted McGinley, Peter Cullen', 'United States', '09-08-2018', 2016, "Kids' TV", 'When a prison ship crash unleashes hundreds of Decepticons on Earth, Bumblebee leads a new Autobot force to protect humankind.'] , [70299204, 'Movie', 'Kidnapping Mr. Heineken', 'Daniel Alfredson', 'Jim Sturgess, Sam Worthington, Ryan Kwanten, Anthony Hopkins, Mark van Eeuwen, Thomas Cocquerel, Jemima West, David Dencik', 'Netherlands, Belgium, United Kingdom, United States', '09-08-2017', 2015, 'Action & Adventure, Dramas, International Movies', 'When beer magnate Alfred "Freddy" Heineken is kidnapped in 1983, his abductors make the largest ransom demand in history.'], ...]
function to format the date:
def date_cruncher(dirty_date): """ This helper function takes in a raw date string and returns a clean date string in "mm-dd-yyyy" format Parameter: dirty_date (str): uncleaned date string in "Month Day, Year" format Returns: cleaned date (str) in "mm-dd-yyyy" format Example: >>> date_cruncher("September 8, 2018") "09-08-2018" """ date_dict = {"jan":"01", "feb":"02", "mar":"03", "apr":"04", "may":"05", "jun":"06", "jul":"07", "aug":"08", "sep":"09", \ "oct":"10", "nov":"11", "dec":"12"} month, day, year = dirty_date.replace(",", "").split() month = date_dict[month[:3].lower()] day = f"0{day}" if len(day) < 2 else day return f"{month}-{day}-{year}"
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started