With the advent of the new media mobile Internet era, the network public opinion in colleges and universities, as an extension of social network public opinion, is also facing a crisis in the prevention, control, and governance system. In this paper, the Fiddler was used to collect the comments and other relevant data of the COVID-19 topic articles on the WeChat Official Accounts of China’s top ten universities in 2020. The BILSTM_LSTM sentiment analysis model was used to analyze the sentiment tendency of the comments, and the LDA topic model was used to mine the topics of the comments with different emotional attributes at different stages of COVID-19. Based on sentiment analysis and text mining, entities and relationships in the theme graph of public opinion events in colleges and universities were identified, and the Neo4j graph database was established to construct the sentimental knowledge graph of the pandemic theme of university public accounts. People’s attitudes in university public opinion are easily influenced by a variety of factors, and the degree of emotional disposition changes over time, with the stage the pandemic is in, and with different commentators; official account opinion topics change with the development of the time stage of the pandemic, and students’ positive and negative comment topics show a diverse trend. By incorporating topic mining into the sentimental knowledge graph, the graph can realize functions such as the emotion retrieval of comments on university public numbers, a source search of security threats in university social networks, and monitoring of comments on public opinion under the theme of the pandemic, which provides new ideas for further exploring the research and governance system of university network public opinion and is conducive to preventing and resolving campus public opinion crises.
Analysis of the Countermeasures of Dealing with the Network Public Opinions on Emergencies of Colleges in Gansu Province
