# Pump it Up: Data Mining the Water Table **URL:** https://community.drivendata.org/c/pump-it-up-data-mining-the-water-table/11.md?page=1 [Latest](https://community.drivendata.org/latest.md) · [Categories](https://community.drivendata.org/categories.md) **Page:** 2 --- ## [Handling Missing Values](https://community.drivendata.org/t/handling-missing-values/1051)
**Author:** [@Ayiso](https://community.drivendata.org/u/Ayiso)\ **Replies:** 1\ **Last updated:** [April 20, 2017, 4:18pm UTC](https://community.drivendata.org/t/handling-missing-values/1051 "2017-04-20T16:18:02Z")
Hello guys Anyone with a suitable technique that they utilized to handle missing categorical/ordinal values without distorting the data . This would be for variables like construction year , funder , installer etc --- ## [What to code the classification rate and what does it mean?](https://community.drivendata.org/t/what-to-code-the-classification-rate-and-what-does-it-mean/639)
**Author:** [@allenkei](https://community.drivendata.org/u/allenkei)\ **Replies:** 2\ **Last updated:** [October 20, 2016, 12:11pm UTC](https://community.drivendata.org/t/what-to-code-the-classification-rate-and-what-does-it-mean/639 "2016-10-20T12:11:18Z")
Hi all, This is my first time in a competition. I am wondering what does the classification rate mean? classification rate = (1/N) \* I( y = y\_hat ) I don't understand if y is equal to y\_hat, then I( y = y\_hat ) re… --- ## [Having trouble submitting?](https://community.drivendata.org/t/having-trouble-submitting/167)
**Author:** [@woodyb23](https://community.drivendata.org/u/woodyb23)\ **Replies:** 13\ **Last updated:** [October 20, 2016, 11:50am UTC](https://community.drivendata.org/t/having-trouble-submitting/167 "2016-10-20T11:50:05Z")
Do the id's have to be in the same order as submission example? --- ## [Classification Rate - XGB Model](https://community.drivendata.org/t/classification-rate-xgb-model/776)
**Author:** [@hammerproject](https://community.drivendata.org/u/hammerproject)\ **Replies:** 4\ **Last updated:** [October 19, 2016, 6:18pm UTC](https://community.drivendata.org/t/classification-rate-xgb-model/776 "2016-10-19T18:18:14Z")
How is calculated the classification rate? We have made a XGB model and obtained a accuracy = 0.88 on validation data ( 30% from the original training set) but when we have sent the result we have obtained only 0.71. w… --- ## [XGBoost only outputting two classes](https://community.drivendata.org/t/xgboost-only-outputting-two-classes/803)
**Author:** [@kamchatang](https://community.drivendata.org/u/kamchatang)\ **Replies:** 2\ **Last updated:** [October 19, 2016, 5:55pm UTC](https://community.drivendata.org/t/xgboost-only-outputting-two-classes/803 "2016-10-19T17:55:57Z")
Essentially I have the same problem as this person. https://discuss.analyticsvidhya.com/t/how-to-resolve-multi-class-prediction-error-in-xgboost-in-r/7030 table(target) 0 1 2 22824 4317 32259 table(pred… --- ## [Scheme\_management](https://community.drivendata.org/t/scheme-management/169)
**Author:** [@Jellis](https://community.drivendata.org/u/Jellis)\ **Replies:** 1\ **Last updated:** [October 13, 2016, 4:42pm UTC](https://community.drivendata.org/t/scheme-management/169 "2016-10-13T16:42:40Z")
Hey I was wondering how anyone here decided to deal with the scheme\_management section. I would like to make things simpler by re-categorizing some of these values into new ones to make things simpler, but I tried lookin… --- ## [Pumps visualization dashboard with Tableau](https://community.drivendata.org/t/pumps-visualization-dashboard-with-tableau/186)
**Author:** [@uioreanu](https://community.drivendata.org/u/uioreanu)\ **Replies:** 4\ **Last updated:** [October 4, 2016, 2:35pm UTC](https://community.drivendata.org/t/pumps-visualization-dashboard-with-tableau/186 "2016-10-04T14:35:38Z")
bubble display of functionality by region: https://public.tableau.com/views/DataMiningtheWaterTableDrivenData\_com/Bubblestatusquantity?:embed=y&:showTabs=y&:display\_count=yes map with regions based on the geographical … --- ## [Column Description](https://community.drivendata.org/t/column-description/321)
**Author:** [@madhulika189](https://community.drivendata.org/u/madhulika189)\ **Replies:** 1\ **Last updated:** [July 20, 2016, 2:28pm UTC](https://community.drivendata.org/t/column-description/321 "2016-07-20T14:28:43Z")
Does anyone know what the column num\_private mean? It has no description in the data dictionary page... Thanks! --- ## [Functional Needs Repair Vs Non Functional -\> Resample due to Class Imbalance?](https://community.drivendata.org/t/functional-needs-repair-vs-non-functional-resample-due-to-class-imbalance/369)
**Author:** [@zhtet13](https://community.drivendata.org/u/zhtet13)\ **Replies:** 1\ **Last updated:** [May 10, 2016, 12:09pm UTC](https://community.drivendata.org/t/functional-needs-repair-vs-non-functional-resample-due-to-class-imbalance/369 "2016-05-10T12:09:30Z")
Hello, The Functional Needs Repair is less than 5000 responses compared to Functional and Non-Functional categories. I believe it is a classic case of class imbalance (approximately 8 and 6 times) I think. Is non-fu… --- ## [First place removed](https://community.drivendata.org/t/first-place-removed/317)
**Author:** [@basvb](https://community.drivendata.org/u/basvb)\ **Replies:** 2\ **Last updated:** [November 5, 2015, 3:05pm UTC](https://community.drivendata.org/t/first-place-removed/317 "2015-11-05T15:05:55Z")
What happened? Somebody got to first place with a 0.85 score in the Pump it Up challenge, which is quite a bit above the other solutions (place 2-18 all where in the 0.82's). But today, three days later, the score is rem… --- ## [Competition End?](https://community.drivendata.org/t/competition-end/124)
**Author:** [@mlandry](https://community.drivendata.org/u/mlandry)\ **Replies:** 3\ **Last updated:** [April 24, 2015, 2:38pm UTC](https://community.drivendata.org/t/competition-end/124 "2015-04-24T14:38:33Z")
The competition page says the competition has 1 week left, but I can't find the actual end date anywhere. Will it complete after the end date, somwehere in the next week (Kaggle has some of their learning competitions on… [Previous page](https://community.drivendata.org/c/pump-it-up-data-mining-the-water-table/11.md)