Shulou(Shulou.com)06/02 Report--

In this issue, the editor will bring you about how to use Python to record the IQ tax harvested by bad movies. The article is rich in content and analyzes and narrates it from a professional point of view. I hope you can get something after reading this article.

Preface

With the vigorous development of the film industry, more and more films appear in the audience's field of vision, enriching everyone's life, and good movies can also let everyone relax and harvest some thinking about life at the same time.

However, there are also some "bad movies" that make people "plug" after watching them, regret contributing to the box office for such "bad movies" and get the "IQ tax" for nothing. Today, we will use Python to cover the IQ tax that has been harvested by bad movies for a few years.

Data acquisition

This time, the data source is also everyone's old friend, Douban, which is affectionately known as "Hornet's Nest". Now there are many platforms that will rate the movie, including Cat's Eye and Taobao, but in comparison, Douban's score is more comprehensive. Some unpopular "bad movies" can only be excavated in Douban.

Admittedly, there will be some "literary filters" in Douban's score, which is more tolerant of literary films. We believe that "Douban's high score is not necessarily really high, but Douban's low score is really low." The range of films selected this time is the domestic films from 2010 to the present:

Finally, the data of more than 3000 movies are obtained. The code is as follows:

# # crawling the drama list And output to excel form driver = webdriver.Chrome () driver.maximize_window () driver.close () driver.switch_to_window (driver.window_handles [0]) url = 'https://movie.douban.com/tag/#/?sort=U&range=2,10&tags=%E7%94%B5%E5%BD%B1,2010%E5%B9%B4%E4%BB%A3, % E4%B8%AD%E5%9B%BD%E5%A4%A7%E9%99%86'js='window.open ("'+ url+'") 'driver.execute_script (js) driver.close () driver.switch_to_window (driver.window_handles [0]) while True: try: js= "var q=document.documentElement.scrollTop=10000000" driver.execute_script (js) driver.find_element_by_class_name (' more') .click () time.sleep (2) except: break Name = [k.text for k in driver.find_elements_by_class_name ('title')] score = [k.text for k in driver.find_elements_by_class_name (' rate')] url = [k.get_attribute ('href') for k in driver.find_elements_by_class_name (' item')] pd.DataFrame ({'name':name) 'score':score,'url':url}) .to_excel (' movie name .xlsx')

Overall data

The first thing to do is to take a look at Douban's overall rating of domestic films, so as to determine the basis for the division of "bad films". First, take a look at the bar chart of the overall rating:

We can see that Douban users are still relatively strict with domestic films. Most films are scored at 6 points, and films with scores above 8 points can be said to be "rare". Therefore, the standard for bad films should be lowered accordingly. Let's take a look at the number of statistics after rounding down the scores:

There is only one domestic film that has scored 9 points after 2010, which can be said to be very difficult. You can guess which movie it is and see if it is the 9-point movie in your mind.

The following is the answer to the mystery:

The only movie that scored 9 points was "I'm not the God of Medicine," which was released in 18 years. I hope there will be more such excellent films in the future, and this expectation is well-founded. Let's take a look at the proportion of bad movies and non-bad movies every year:

It can be seen that since the proportion of bad films and super-bad films peaked in 16 years, the proportion of bad films has been declining gradually since 17 years. It is believed that the proportion of bad films will also gradually decline in the future.

Popularity list

After an overall review, we have determined the basis for the classification of bad films and super-bad films, dividing the films under 4 points into bad films and those below 3 points into super bad films. Let's take a look at their respective popularity lists:

We can see that in all the films, the ratings of the popular TOP10 are still good, and the wandering Earth, the God of Medicine and Nezha also do very well at the box office. Obviously, this is not what we need. Let's take a look at the popularity lists of bad movies and super bad movies:

Warm congratulations to "Shanghai Fortress" for mentioning the champion of the two popularity lists with a score of 2.9 points and 217110 comments. "Love apartment" is also on the list because of its "big bluff" marketing. I wonder if the upcoming "Love apartment 5" can restore some reputation for this series.

Box office rankings

Similarly, let's take a look at the box office rankings of all the films, bad movies and super bad movies to see which "bad movies" are frantically harvesting everyone's IQ tax. first, take a look at the box office rankings of the films:

The box office of Xihong City, the 10th richest man, has reached 2.5 billion, which shows the rapid development of the box office market. This year's two National Day films "me and my Motherland" and "Chinese Captain" ranked eighth or ninth respectively. I believe that this list will continue to change in the future.

"the richest man in Xihong City" also has the lowest score on the list with a score of 6.5 points. It seems that "the richest man in Xihong City" has become a benchmark, and 6.5 points is also the bottom line of a box-office blockbuster film. Let's take a look at those bad movies and super-bad movies that frantically harvest everyone's IQ tax:

The TOP10 in the box office list of bad movies has exceeded 260 million, and Tianzhu and Love Apartments have reaped 750 million and 550 million of the box office respectively, frantically harvesting everyone's IQ tax. I believe that in the future, with the increase of everyone's requirements for the film, the phenomenon of crazy harvest IQ tax will gradually decrease.

Unexpectedly, even the TOP10 of super bad movies can earn more than 50 million of the box office, and four films have grossed more than 100 million. Here, we would like to remind you that "watching movies is risky, so you should be careful in choosing films."

Actor list

The birth of a bad film must be inseparable from the efforts of "actors". Let's take a look at the actors with the highest and lowest average scores in the movies:

There is no need to repeat the actors with high ratings. They have all gone through the challenges of the market and the audience, but at present, there is no actor who can score 7 after starring in more than 5 films. it is true that part of the reason is Douban's strict requirements for domestic production, but on the other hand, it is also urging filmmakers to make continuous progress.

Let's take a look at the actors at the bottom of the list. Let's first take a look at BOTTOM10:

Seeing this list, there is a sense of trance, confirming that this is not the list of hosts or comedians or comedians, we can't help but ask: is there anything wrong with everyone? The happy family is even more "dominating". Du Haitao is at the top of the list with his superb acting skills and outstanding appearance. I believe he will bring more "amazing" works to everyone in the future. Wu Yifan also appeared on the list on behalf of rappers, filling in the gaps in the list of singers.

As too many "cross-border" actors appear on the list BOTTOM10, so many actors in everyone's mind do not appear on the list, so let's continue to watch BOTTOM11-20, this list seems a bit normal, but many names that should appear in TV series are also on the list.

It seems that there are differences between movies and TV dramas. Actors who can shine in TV dramas may not be able to perform as well in movies. Considering the addition of TV actors, continue to enlarge the list to BOTTOM21-30:

This list has finally become more normal, and many of our "seed contestants" have appeared on the list as expected. In particular, the inclusion of Huang Xiaoming and Angelababy, a model couple, has further enhanced the credibility of the list. In the future, I also hope that they can continue to work together to bring wonderful works to everyone. Many people may doubt it, and our reply is simple: I don't want you to believe it. I want me to believe it!

The above is how to use Python to record the IQ tax harvested by bad movies. If you happen to have similar doubts, please refer to the above analysis to understand. If you want to know more about it, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.