Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: Re: Web APIs and JSON file format reading
From
Andrew Dyck <[email protected]>
To
[email protected]
Subject
Re: st: Re: Web APIs and JSON file format reading
Date
Mon, 20 Dec 2010 11:22:14 -0800
Thanks Sergiy,
I'm a little late to the game for the Apps for Development challenge
but I'm really looking forward to what the winners come up with!
I'm not exactly a Twitter analyst, but I've heard of research using
data from Twitter to predict movie sales (apparently twitter
conversation can predict movie sales with >90% accuracy). I've also
heard of quants using Twitter to predict stock price changes and
epidemiologists using it to track flu outbreaks.
Cheers,
Andrew
On Sun, Dec 19, 2010 at 11:40 PM, Sergiy Radyakin
<[email protected]> wrote:
> On Sun, Dec 19, 2010 at 7:40 PM, Andrew Dyck <[email protected]> wrote:
>> Hi Stata users,
>>
>> I'm interested in using Stata to access data from web APIs such as
>> data.worldbank.org or Twiter. I use 64-bit Stata MP for Windows and
>
> Dear Andrew,
> the data from the World Bank also comes in a CSV format, archived in
> ZIP files. You can download the data of your interest with -copy- from
> the web address to your local drive, then unpack with the -unzipfile-
> command (undocumented in Stata 10, documented in Stata 11). Then
> -insheet- the data tables you want.
>
> If you are up to the "Apps for development" competition: good luck!
>
> The data catalog with direct links to databases is available here:
> data.worldbank.org/data-catalog
>
> Best regards,
> Sergiy Radyakin
> Economist, Research Department, The World Bank
>
>
> PS: what data is available on Twitter?
>
>
>
>> Linux.
>>
>> I'm aware of the -net-, -copy- and -webuse- commands, however, my
>> searches so far haven't uncovered any tools for reading in data
>> directly from an API. At this time it seems that this may not be
>> possible in Stata without using an external python or perl script.
>> However, if you have any experience in using JSON with Stata I'd be
>> very happy to hear from you.
>>
>> I have begun research into writing a native Stata module (using mata)
>> for reading JSON data from a web API but I thought I'd tap the
>> Statalist knowledge bank first to:
>>
>> 1) stop me early if it's just not possible or already done;
>> 2) suggest any strategies for how to go about this; and
>> 3) see if there is any interest in such a feature or if users are
>> already using some other methods that would work better than something
>> native to Stata.
>>
>> Any help, advice or links to more info would be greatly appreciated.
>>
>> Thanks,
>> Andrew
>> *
>> * For searches and help try:
>> * http://www.stata.com/help.cgi?search
>> * http://www.stata.com/support/statalist/faq
>> * http://www.ats.ucla.edu/stat/stata/
>>
>
> *
> * For searches and help try:
> * http://www.stata.com/help.cgi?search
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/