擅长:python、mysql、java
<p>您还可以使用<code>pandas</code>和<code>collections.Counter</code></p>
<p>例如:</p>
<pre><code>import collections
import pandas as pd
from tabulate import tabulate
with open("data_file.csv") as file:
next(file, None) # skip the header
counter = collections.Counter([line.strip() for line in file])
output = collections.defaultdict(dict)
for user_and_ip, ip_to_user_count in counter.items():
user, ip = user_and_ip.split(",")
output[ip].update({user: ip_to_user_count})
df = pd.DataFrame(output).fillna("")
print(tabulate(df, headers="keys"))
df.to_csv("user_to_ip.csv")
</code></pre>
<p>输出:</p>
<pre><code> 10.12.6.54 10.12.6.55 10.12.6.51
XXXXXX24 5.0
XXXXXX25 5.0
XXXXXX21 4.0
</code></pre>
<p>以及<code>.csv</code>文件:</p>
<p><a href="https://i.stack.imgur.com/gvQxS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gvQxS.png" alt="enter image description here"/></a></p>