Design and Implementation of Network Public
Opinion Analysis System
Abstract: Since entering the 21st century, computer technology has flourished, and many changes have taken
place in people's lives. For example, the dissemination of information and the publication of speeches are becoming
faster and faster. Contemporary netizens can quickly understand the news and dynamics of today's society through
online platforms. In addition, they can also use the comment function of various platforms to express their own
opinions or opinions. It can be seen that computer technology has not only changed people's lives in terms of
clothing, food, housing, and transportation, but also contributed to modern life in various fields.
Although the internet is now very developed, netizens can speak out about some phenomena through various
online platforms (such as Sina Weibo), as a netizen, it is necessary to publish positive and energetic comments or
Weibo, love your country or city and not defame it. The internet also respects the freedom of expression of netizens,
but there will also be monitoring of some netizens who create rumors and incidents. Before the rapid development
of computer technology, it was very troublesome for people to search for specific statements or comments on the
network. People needed to view all specific users' microblogs and then scroll through them one by one. However,
this search method was first inefficient because a person's energy was limited, and people needed to view each user's
microblogs, and the refresh of microblogs was fast, New comments or forwarding may occur at intervals of a few
minutes. Secondly, this method has poor timeliness, and comments on Weibo or Weibo cannot be quickly and
timely refreshed.
This system is developed using Python language and MySQL database, providing multiple functions such as
speech analysis, speech management, and user management for social network management departments. It allows
users to conduct speech analysis and management based on their own city or region without having to check
everyone's Weibo account. This ensures the privacy and freedom of expression of netizens, You can view local
related public opinion or negative comments with maximum efficiency.
Keywords Network Public Opinion Analysis; Public Sentiment; Python； MYSQL
