给定列中出现频率最高的值

SELECT column_name
FROM table_name
GROUP BY column_name
ORDER BY COUNT(*) DESC
LIMIT 1;

import pandas as pd

# 假设df是一个DataFrame，'column_name'是要计算众数的列名
mode_value = df['column_name'].mode()[0]
print(mode_value)

SELECT column_name, COUNT(*) AS frequency
FROM table_name
GROUP BY column_name
HAVING frequency = (
    SELECT MAX(frequency)
    FROM (
        SELECT column_name, COUNT(*) AS frequency
        FROM table_name
        GROUP BY column_name
    ) AS subquery
);

import pandas as pd

# 假设df是一个DataFrame，'column_name'是要计算众数的列名
mode_values = df['column_name'].mode()
print(mode_values)