Spaces:
Sleeping
Sleeping
File size: 1,343 Bytes
0fe6e4d | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 | import pandas as pd
import numpy as np
import traceback
def execute_python_query(df, query_type, params=None):
try:
if query_type == "unique_count":
column = params["column"]
return {
"success": True,
"result": int(df[column].nunique())
}
elif query_type == "missing_values":
result = (
df.isnull()
.mean()
.mul(100)
.round(2)
.to_dict()
)
return {
"success": True,
"result": result
}
elif query_type == "top_values":
column = params["column"]
top_n = params.get("top_n", 10)
result = (
df[column]
.value_counts()
.head(top_n)
.to_dict()
)
return {
"success": True,
"result": result
}
else:
return {
"success": False,
"message": "Unknown query type"
}
except Exception:
return {
"success": False,
"error": traceback.format_exc()
} |