Python can also analyze official accounts

Foreword
Unconsciously, it has been more than a year since I wrote a small official account, and I still have a little understanding of the status of my official account.

This time, from a data point of view, the editor will take a look at the operation status of the editor over the past year.

Since the editor insists on originality, the number of articles is not too many, so there is no crawler to crawl the data, but the data is manually entered.

Two tables of data, article information table, reprint status table:

Through these two tables, perform exploratory description analysis, and then drill down analysis, the requirements are as follows:

Total number of articles published
Check the wording status of the article title
User growth trend
Reading interval
Take a look, like, and the distribution of the amount of appreciation
Proportion of original, reprinted, and advertising articles
Percentage of article types
Is the number of readings, taking a look, likes, praises, and reposts relevant?
. Which type of article has high reading volume
The impact of pushing to other group chats on readings
What are reprinted and what type
The number of reprinted readings is compared with the readings of the original text
Which official account has the most reprints and cumulative reading
For this number, the type of articles with high reading count

Kinoshita Learn Python

After more than a year of operation, a total of 64 articles have been published. Readers who have followed for a long time know that the editor publishes about two articles per month, so there are only so many articles in total:

What is the proportion of original, reprinted, and advertising in these articles? Readers who have followed for a long time know that the editor still insists on originality more:

In these articles, what is the wording of the title of the article? The editor made a word cloud in the shape of a file, and found that Python, crawlers, analysis, and data are more informative:

What is the number of users of the editor? The editor is just a small trumpet owner, does not load a lot, insists on originality, so the growth in the early stage is relatively slow, and after accumulating some quality articles, it grows faster:

The number of readings can reflect the overall distribution of the number of readings. To a certain extent, it reflects that the higher the number of readings, the more interesting the article is for everyone. The editor divides the number of readings into several intervals, mostly between 150-450 :

Not only the number of readings, the number of reads, the number of likes, and the amount of appreciation also reflect the reader's interest in the article to a certain extent. The editor checks the distribution of all articles to see that each article is mostly 5, and the number of likes is 1- Between 20, appreciation is mostly distributed between 0-6 yuan:

The most popular article category in the editor is reptiles, because at first it is reptile articles, followed by others, including advertisements, tools, system environment, recommended books, self-summary, article summary, etc.:

The number of readings, take a look, like, admire, and reprinted is the number of readings and the look, the more you read, the number of look may also increase:

So what kind of articles have a lot of reading? The editor has the highest number of crawlers. Then think about it, I always wrote crawlers in the early stage, and started writing after data analysis. The number is not much, and the number of readings is relatively small:

The editor sometimes shares some group chats. Does sharing affect the reading count? From the results, the number of shared readings will be relatively higher:

Several of the editor’s articles are of some quality, and have been reprinted by some bigwigs. The most one has been reprinted 9 times:

Let's take a look at the number of readings of the original text that was reprinted. Compared with the number of readings after the big guys reprinted, the trumpet owner is always the trumpet owner:

The reprinted official accounts have these, and some of them are reprinted more than once, which seems to be quite good:

Articles with a high number of readings, the editor's official account reading is greater than 400, even if it is high, after all, the trumpet owner, which type of article is the most? The most can reflect the reader's interest in such articles to a certain extent:

At this point, the editor briefly analyzed the operation status, and I would like to know more to try. The editor provides data sets and codes for your reference.

** Source code acquisition**

Follow the WeChat public account "Musia Learning Python" and reply to "Musia" to get