pandas中的position列包含从1到15的值，votes percentage列包含从0到100的值

import pandas as pd

data = {
    'position': range(1, 16),
    'votes_percentage': [23.4, 45.6, 78.9, 12.3, 56.7, 89.0, 34.5, 67.8, 90.1, 23.0, 45.6, 78.9, 12.3, 56.7, 89.0]
}

df = pd.DataFrame(data)
print(df)

df_sorted = df.sort_values(by='votes_percentage', ascending=False)
print(df_sorted)

threshold = 50
df_filtered = df[df['votes_percentage'] > threshold]
print(df_filtered)

mean_votes = df['votes配售率'].mean()
max_votes = df['votes_percentage'].max()
min_votes = df['votes_percentage'].min()

print(f"Mean Votes: {mean_votes}")
print(f"Max Votes: {max_votes}")
print(f"Min Votes: {min_votes}")

import matplotlib.pyplot as plt

plt.hist(df['votes_percentage'], bins=10)
plt.xlabel('Votes Percentage')
plt.ylabel('Frequency')
plt.show()