擅长:python、mysql、java
<p>也许<code>value_counts</code></p>
<pre><code>(df.drop_duplicates()
.Site_Where_Served
.value_counts()
.to_frame('Site_Visit_Count')
.rename_axis('Site_Where_Served')
.reset_index()
)
Site_Where_Served Site_Visit_Count
0 hospital 3
1 inpatient 1
</code></pre>