ddrillini / uiuc-wendy

Issue tracker for UIUC's ITG cabinet, and public assets.
http://ddrillini.club
2 stars 1 forks source link

coin data analytics #12

Open andrewipark opened 6 years ago

andrewipark commented 6 years ago

Find some way to export coin analytics data, as suggested by Ian.

I think it's an ini file somewhere...

clarification: It's already on the machine, but it's not n an intuitive location

ianklatzco commented 6 years ago

I think Tucker might be interested in doing some python on the data.

El El mar, feb. 13, 2018 a las 15:23, andrewipark notifications@github.com escribió:

Find some way to export coin analytics data, as suggested by Ian.

I think it's an ini file somewhere...

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/ddrillini/uiuc-wendy/issues/12, or mute the thread https://github.com/notifications/unsubscribe-auth/ABayNSenW4Wk9j5xif61Ov2OONzwHfJ_ks5tUf1EgaJpZM4SEa4- .

--

andrewipark commented 6 years ago

pues, el archivo de Coins.xml en mi computadora:

<?xml version="1.0" encoding="UTF-8" ?>

<Bookkeeping>
    <Data>
        <Coins Day='292' Hour='14' Year='2017'>1</Coins>
        <Coins Day='303' Hour='0' Year='2017'>1</Coins>
        <Coins Day='335' Hour='10' Year='2017'>1</Coins>
        <Coins Day='361' Hour='9' Year='2017'>1</Coins>
        <Coins Day='3' Hour='20' Year='2018'>1</Coins>
        <Coins Day='4' Hour='13' Year='2018'>2</Coins>
        <Coins Day='5' Hour='22' Year='2018'>1</Coins>
        <Coins Day='23' Hour='18' Year='2018'>1</Coins>
    </Data>
</Bookkeeping>

El formato es obvio

tcampbell0092 commented 6 years ago

Oh hey, definitely would be interested in helping out.

tcampbell0092 commented 6 years ago

is there any way to get access to a copy of the ini file?

ianklatzco commented 6 years ago

here's a link to download, or if you wanna go the extra mile and learn something new you can clone the git repo (install git, then git clone https://github.com/ddrillini/uiuc-wendy/ on git bash).

ianklatzco commented 6 years ago

tucker, if you've got any questions or dunno where to get started, pls feel free to ask questions here c:

tcampbell0092 commented 6 years ago

So if i'm reading right, is the idea to basically capture how many coins go in the machine a day? and to write a program that mimics inserting coins into the machine and saves it?

andrewipark commented 6 years ago

Coins.xml is already generated by Stepmania.

ianklatzco commented 6 years ago

so Coins.xml is a log of all the money that's gone in the machine. i think it would be a cool project to be able to make a python program that asks for the number of coins in a given week, for example, or finds out what hour of the day is the most popular

you should check out https://docs.python.org/3/library/xml.etree.elementtree.html it should walk you through getting started

ianklatzco commented 6 years ago

give it a shot for a bit, and then when you get bored / frustrated lemme know when you've got a free hour and i'll remote desktop into your computer or come over or meet up at the cab or something and i can help you out c:

trevorm4 commented 5 years ago

Made charts for nov-15 file

coins by month coins by day coins by hour

ianklatzco commented 5 years ago

todo: extract old xml file from busted old pc (if it exists)

@andrewipark, you mirrored just the simfiles, right? and wiped the rest of the mattpc?

i want coins.xml but i don't think we saved it. i think there's one on there that should have coin data from august to november. i want this so i can make charts showing how much value we've generated for the rec room.

ianklatzco commented 5 years ago

~~i found a BUNCH of backups Google Drive/DDRIllini/3.95-backup/openitg/Data/Coins.xml /Users/ianklatzco/Dropbox/files/backup/itgbackup/In The Groove 2/Stats.xml which goes back to 2004~~

i got overexcited, one is just a 3.95 from fa2018 (just me being safe probs) and the other is just a usb stick backup

ianklatzco commented 5 years ago

i grabbed the last off data! @trevorm4 feeeeel like taking a look? https://www.dropbox.com/s/wy477gvknr0x7dd/original-itg-coins.xml?dl=0

the data i'm looking for is "how much money does ITG make every month in 2015 vs 2018-19"