coin data analytics

[andrewipark]

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]

I think Tucker might be interested in doing some python on the data. El El mar, feb. 13, 2018 a las 15:23, andrewipark <[email protected]> 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 <#12>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABayNSenW4Wk9j5xif61Ov2OONzwHfJ_ks5tUf1EgaJpZM4SEa4-> .

-- - Ian Klatz.co <https://klatz.co>

[andrewipark]

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]

Oh hey, definitely would be interested in helping out.

[tcampbell0092]

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

[ianklatzco]

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]

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

[tcampbell0092]

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]

Coins.xml is already generated by Stepmania.

[ianklatzco]

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]

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]

Made charts for nov-15 file

[ianklatzco]

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]

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]

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"