2012-09-03

Common values in two datasets arranged by date.

http://pastebin.com/2Vw9SDTF

Simple code written in python. Takes out values from common dates in two lists/arrays.



what is correlation between such datasets?

2003.05.18 1
2003.05.19 2 26
2003.05.20
2003.05.21 25
2003.05.22 5 32
2003.05.23 2 32
2003.05.24 3 38
2003.05.25 2 36
2003.05.26 39
2003.05.27 1 32
2003.05.28 2
2003.05.29 3 35
2003.05.30 37
2003.05.31 4 32
2003.06.01 7 37
2003.06.02 8
2003.06.03 9 32
2003.06.04 1 35
2003.06.05 2 39
2003.06.06 3 35
2003.06.07 4 37
2003.06.08 31
2003.06.09 5 31
2003.06.10 6 35
2003.06.11 7
2003.06.12 8
2003.06.13 9
2003.06.14
2003.06.15 0
2003.06.16 12 1
usually excel helps. but sometimes when data comes from database, this becomes a huge pain.
of course, maybe out there are similar python tools and stuff to calculate such thingies. if you, my dear reader, know other possible ways to obtain correlation for example, I will be glad to hear them.


Nav komentāru:

Ierakstīt komentāru