Bookmark and Share

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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index