# ---
# jupyter:
#   jupytext:
#     text_representation:
#       extension: .py
#       format_name: light
#       format_version: '1.5'
#       jupytext_version: 1.14.4
#   kernelspec:
#     display_name: Python 3
#     language: python
#     name: python3
# ---

import numpy as np
import pandas as pd
df=pd.read_csv('xinshengurl.csv')

df.describe()

# +
df['url']=df['url'].apply(lambda x:x[x.find('&id=')+1:] )

df.sort_values(by='reply',ascending=False)[:30]
# -

# 3030个id发表了3975个帖子

df.groupby('author').count().reset_index().sort_values('title',ascending=False)

# +
authoryun=df[df['author'].str.contains('云')]

print(authoryun.count())
print(authoryun)

StarcoderdataJupyterScriptsDedupFiltered