# Using UCI data to achieve 0.1311 on LB, just for fun here

**URL:** <https://community.drivendata.org/t/using-uci-data-to-achieve-0-1311-on-lb-just-for-fun-here/883>\
**Category:** Warm Up: Predict Blood Donations\
**Created:** [December 8, 2016, 3:12pm UTC](https://community.drivendata.org/t/using-uci-data-to-achieve-0-1311-on-lb-just-for-fun-here/883 "2016-12-08T15:12:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ymcdull](https://yyz2.discourse-cdn.com/flex028/user_avatar/community.drivendata.org/ymcdull/32/452_2.png) [@ymcdull](https://community.drivendata.org/u/ymcdull)\
**Post date:** [December 8, 2016, 3:12pm UTC](https://community.drivendata.org/t/using-uci-data-to-achieve-0-1311-on-lb-just-for-fun-here/883/1 "2016-12-08T15:12:18Z")

</div>

Using UCI data to achieve 0.1311 on LB, just for fun here 😉

> import pandas as pd

> source = pd.read\_csv(“[https://archive.ics.uci.edu/ml/machine-learning-databases/blood-transfusion/transfusion.data](https://archive.ics.uci.edu/ml/machine-learning-databases/blood-transfusion/transfusion.data)”)  
> test = pd.read\_csv(“[https://s3.amazonaws.com/drivendata/data/2/public/5c9fa979-5a84-45d6-93b9-543d1a0efc41.csv](https://s3.amazonaws.com/drivendata/data/2/public/5c9fa979-5a84-45d6-93b9-543d1a0efc41.csv)”)

> source.columns = [“monthsF”, “donations”, “volumnCC”, “monthL”, ‘target’]  
> test.columns = [“id”, “monthsF”, “donations”, “volumnCC”, “monthL”]

> source = source.astype(str)  
> source[“target”] = pd.to\_numeric(source[“target”])  
> test = test.astype(str)

> source[“combined”] = source.apply(lambda x: “-”.join([x[“monthsF”], x[“donations”], x[“volumnCC”], x[“monthL”]]), axis = 1)  
> mydict = dict(source.groupby([“combined”])[“target”].mean())

> test[“combined”] = test.apply(lambda x: “-”.join([x[“monthsF”], x[“donations”], x[“volumnCC”], x[“monthL”]]), axis = 1)  
> test[“Made Donation in March 2007”] = list(test.combined.apply(lambda x: mydict))

> test[[“id”, “Made Donation in March 2007”]].to\_csv(“using\_uci\_data.csv”, index = False)

---

<div class="post-metadata">

**Author:** ![Gillesvdw](https://avatars.discourse-cdn.com/v4/letter/g/a8b319/32.png) [@Gillesvdw](https://community.drivendata.org/u/Gillesvdw)\
**Post date:** [December 18, 2016, 10:03am UTC](https://community.drivendata.org/t/using-uci-data-to-achieve-0-1311-on-lb-just-for-fun-here/883/2 "2016-12-18T10:03:36Z")

</div>

Wow ruining the leaderboard of a competition. So much fun that must be…

---

<div class="post-metadata">

**Author:** ![epattaro](https://avatars.discourse-cdn.com/v4/letter/e/6f9a4e/32.png) [@epattaro](https://community.drivendata.org/u/epattaro)\
**Post date:** [January 19, 2017, 12:23pm UTC](https://community.drivendata.org/t/using-uci-data-to-achieve-0-1311-on-lb-just-for-fun-here/883/3 "2017-01-19T12:23:55Z")

</div>

nice! i will download it and give it a try. good idea!