read_ga bug

[benoitpointet]

Cannot get io.ga to work since update to 14.1 (using 0.15.0 right now):

TypeError: list indices must be integers, not Index

import pandas.io.ga as ga
df = ga.read_ga(
    property_id  = "UA-XXX",
    profile_id   = "XXX",
    metrics      = ['users'],
    dimensions   = ['dayOfWeek','hour'],
    start_date   = "2014-02-03",
    end_date     = "2014-08-03"
)

[jreback]

GA has not gotten much care and feeding in quite a while. Biggest problem is it doesn't have really any automatic tests. So if you'd like to debug, pls provide a full-traceback (and debug so that you can show what the various variables are).

[jreback]

http://stackoverflow.com/questions/26858077/pandas-io-ga-not-working-for-me-solved

looks like passing index_col=0 will solve this.

as I said above, still interested in better testing/improvements in ga. ping if you are interested.

[benoitpointet]

Thanks it somehow works. Don't get how and when that got broken.

I think the first contribution I could make is at the documentation level. Since there's really not much atm.

[jreback]

@benoitpointet that would be fantastic actually, open issue is #3508

I would create a new sub-section in remote_data.rst. Put a fully-working example (but in a code-block as the stumbling block here is authentication, so it won't actually work). But run it on your system (and you can simply change the displayed names/pw's before you paste it in). Actual code use would be bonus, e.g. show a snippet of the results).

!

[jreback]

@benoitpointet actually would be really helpful if you could pull down this branch: #8785

and run it and see if the Warning's disappear (they are from a change in the way Index ops worked in 0.15.0), but never tested in ga, so didn't see them until the SO post.

and lmk