Prev: Image processing with ImageCompose
Next: undocumented feature: TableView
From: jroge on 7 Oct 2009 07:08
I am looking for some advice for directly importing data from Google
Trends? I am able to download the CSV files from Google and then load
into Mathematica easily enough, but I would rather skip the
intermediate steps and directly pull the data from Google into my
Mathematica notebook. I think where I am getting stuck is that Google
requires authentication and programming that into Mathematica is a bit
beyond my skill sets. Any thoughts?

Jon

From: Szabolcs Horvát on 8 Oct 2009 07:52
On 2009.10.07. 13:08, jroge wrote:
> I am looking for some advice for directly importing data from Google
> Trends? I am able to download the CSV files from Google and then load
> into Mathematica easily enough, but I would rather skip the
> intermediate steps and directly pull the data from Google into my
> Mathematica notebook. I think where I am getting stuck is that Google
> requires authentication and programming that into Mathematica is a bit
> beyond my skill sets. Any thoughts?
>

If you don't mind fiddling with Python a bit, you could use this script:

http://www.juiceanalytics.com/openjuice/programmatic-google-trends-api/

From: Chris Osborn on 9 Oct 2009 07:25
On Oct 7, 6:08 am, jroge <jr...(a)mac.com> wrote:
> I am looking for some advice for directly importing data from Google
> Trends? I am able to download the CSV files from Google and then load
> into Mathematica easily enough, but I would rather skip the
> intermediate steps and directly pull the data from Google into my
> Mathematica notebook. I think where I am getting stuck is that Google
> requires authentication and programming that into Mathematica is a bit
> beyond my skill sets. Any thoughts?
>
> Jon

Have you tried "Import?" It allows you to specify a URL; perhaps it
will suffice.

Chris

From: telefunkenvf14 on 10 Oct 2009 07:10
On Oct 7, 6:08 am, jroge <jr...(a)mac.com> wrote:
> I am looking for some advice for directly importing data from Google
> Trends? I am able to download the CSV files from Google and then load
> into Mathematica easily enough, but I would rather skip the
> intermediate steps and directly pull the data from Google into my
> Mathematica notebook. I think where I am getting stuck is that Google
> requires authentication and programming that into Mathematica is a bit
> beyond my skill sets. Any thoughts?
>
> Jon

I was trying to do something similar just the other day... However,
the examples in Mathematica's documentation, concerning using web
services to access Google, are broken. I believe Chris Osborn's
suggestion of using Import[] should work.

I'll play around this weekend trying to write some functions
corresponding to the google search url options (more info here:
http://www.our-picks.com/archives/2007/01/30/google-search-urls-revealed-or-how-to-create-your-own-search-url/).
Maybe then we/you can help adapt the code for the Trends searches.

I generally find that getting data into Mathematica can be a bit
cumbersome--probably because I've been spoiled/ruined by pointy-clicky
my whole life. Also, if you have Excel 2007 you should be able to do
the same type of thing. (Querying and automatically having Excel pull
the data. Actually read something about customizing Google queries for
Excel the other day. Bookmarked it somewhere...)

From: jroge on 11 Oct 2009 08:06
On Oct 10, 4:10 am, telefunkenvf14 <rgo...(a)gmail.com> wrote:
> On Oct 7, 6:08 am, jroge <jr...(a)mac.com> wrote:
>
> > I am looking for some advice for directly importing data from Google
> > Trends? I am able to download the CSV files from Google and then load
> > into Mathematica easily enough, but I would rather skip the
> > intermediate steps and directly pull the data from Google into my
> > Mathematica notebook. I think where I am getting stuck is that Google
> > requires authentication and programming that into Mathematica is a bit
> > beyond my skill sets. Any thoughts?
>
> > Jon
>
> I was trying to do something similar just the other day... However,
> the examples in Mathematica's documentation, concerning using web
> services to access Google, are broken. I believe Chris Osborn's
> suggestion of using Import[] should work.
>
> I'll play around this weekend trying to write some functions
> corresponding to the google search url options (more info here:http://www=
..our-picks.com/archives/2007/01/30/google-search-urls-revea...).
> Maybe then we/you can help adapt the code for the Trends searches.
>
> I generally find that getting data into Mathematica can be a bit
> cumbersome--probably because I've been spoiled/ruined by pointy-clicky
> my whole life. Also, if you have Excel 2007 you should be able to do
> the same type of thing. (Querying and automatically having Excel pull
> the data. Actually read something about customizing Google queries for
> Excel the other day. Bookmarked it somewhere...)

Import is certainly the right function, it is actually the one I was
using. The roadblock I am running into the user authentication. Google
requires you to first log-in to you account . Where I am getting stuck
is the proper way to represent the user credentials when I run Import.
The Wolfram Blog post on tweeting from mathematica is the closest
documentation I can find, but that is an apples to oranges scenario.

 |  Next  |  Last
Pages: 1 2
Prev: Image processing with ImageCompose
Next: undocumented feature: TableView