PHPMem v2.0.1
Version
1.6.45
Uptime
15 days 9 hours 32 minutes 20 seconds
Memory
Total
512MB
Used
24,01MB (4.69%)
Free
487,99MB
Keys
Current
27 650
Total (since start)
33 978
Evictions
0
Reclaimed
160
Expired Unfetched
0
Evicted Unfetched
0
Connections
Current
11 / 1 024 max
Total
170 602
Rejected
0
llm:2d2651db0375f5b7878cde121589c3ce000a0ca4163374c37175eabe09bd71e4
Edit
Based on the column metadata gathered, the single most surprising and counterintuitive finding is that the **`Switch to order menu`** column provides absolutely zero information or variance.
* **The Data:** The column has exactly `~1 distinct` value, and its range is explicitly `false..false`.
* **Why it's surprising:** Despite being included as a boolean feature in a dataset of `~10020 distinct` restaurants, not a single restaurant actually has this feature enabled. It is a completely redundant column.
### Other Notable Anomalies Supported by the Data
While the dead `Switch to order menu` column is the most glaring structural quirk, the summary statistics reveal a few other highly counterintuitive points:
1. **Extreme "Average Cost for two":** The cost ranges from a minimum of `0` to a staggering maximum of `800000`. A cost of `0` is highly counterintuitive for a restaurant.
2. **No Perfect Ratings:** Despite having `~10020 distinct` restaurants and a maximum of `10934` votes for a single location, the `Aggregate rating` maxes out at `4.9`. Not a single restaurant in the dataset achieved a perfect 5.0 rating.
3. **High Volume of Chains/Duplicates:** There are `~10020 distinct` `Restaurant ID`s but only `~7003 distinct` `Restaurant Name`s. This indicates that roughly 30% of the dataset consists of chain restaurants or locations sharing the exact same name.
### What Remains Uncertain
Because the investigation was halted at the metadata level, I can only see the aggregate boundaries of the data. I cannot confirm:
* **The cause of the extreme costs:** While the maximum of `800000` is almost certainly due to unnormalized currencies (the `Currency` column has `~11 distinct` values, which likely includes currencies like the Indonesian Rupiah), I cannot prove which currency it belongs to. Furthermore, it is entirely uncertain whether the `0` cost represents missing data, a free promotion, or a data entry error.
* **The reason for the dead column:** It is unknown why `Switch to order menu` is universally false (e.g., whether it is a deprecated feature in the Zomato API or just unsupported in the specific cities sampled).