我有幾個 csv 列存盤彩票號碼和其他一些資訊，例如開獎日期。我需要得到一個字典<繪制的數字，這個數字在所有列中出現的次數> 作為我的輸出。到目前為止，我已經能夠單獨列印每列中出現的次數。
# Import libraries
import pandas as pd
from IPython.display import display
# Turn csv file into a pandas dataframe
df = pd.read_csv("LOTTOMAX.csv")
# Only select columns that I'm interested in. Csv file contains additional useless info.
selection = df[['NUMBER DRAWN 1', 'NUMBER DRAWN 2', 'NUMBER DRAWN 3', 'NUMBER DRAWN 4',
'NUMBER DRAWN 5', 'NUMBER DRAWN 6', 'NUMBER DRAWN 7']]
# Loop over columns and apply value_counts(). Output to terminal.
for col in selection.columns:
# I have included this to make terminal output more readable.
print('-' * 40 col '-' * 40 , end='\n')
display(selection[col].value_counts().to_string())
uj5u.com熱心網友回復：
我做這個專案是為了好玩。想在 bclc 網站上復制一個功能。也許這會對某人有所幫助。
# Import libraries
import pandas as pd
from collections import Counter
import matplotlib.pyplot as plt
# Read csv file
df = pd.read_csv("LOTTOMAX.csv") #csv file https://www.playnow.com/resources/documents/downloadable-numbers/LOTTOMAX.zip
cols = ['NUMBER DRAWN 1', 'NUMBER DRAWN 2', 'NUMBER DRAWN 3', 'NUMBER DRAWN 4',
'NUMBER DRAWN 5', 'NUMBER DRAWN 6', 'NUMBER DRAWN 7']
results = []
# Add data to a list
for i in cols:
results = df[i].tolist()
# Count occurrences
occurr = Counter(results)
# Display histogram
plt.bar(list(occurr.keys()), occurr.values(), color='g')
plt.xlabel("Numbers Drawn")
plt.ylabel("Frequency")
plt.show()
這個解決方案并不完美，但它確實有效。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/455917.html