Databases
StackOverflow2013
Postsdbo
POArranging data to be more readable
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POArranging data to be more readable
    text
    copied!<p>I am using Twitter-tools api.GetSearch to find information on Twitter. The code works but the data it retrieves is jumbled per se. How would I go by making the data more understandable. For example, breaking the data down by each individual Tweet. Right now the data looks like this..</p> <p>[u'Sales at Apple stores have fallen 4.5% per square foot. The search for a new head of retail: <a href="http://t.co/YQ0LQGXfXp">http://t.co/YQ0LQGXfXp</a> $AAPL', u'In rare move, Obama administration vetoes ban on sale of some Apple devices. <a href="http://t.co/UMCTcC1TQu">http://t.co/UMCTcC1TQu</a> $AAPL', u"AT&amp;T claims it's the 1st U.S. store, even before Apple, to do away completely w/o cash registers. <a href="http://t.co/pWmTQCHlBm">http://t.co/pWmTQCHlBm</a> $T @ATT $aapl $VZ", u"Justice Department is seeking oversight over Apple's iTunes store to curb anticompetitive behavior.</p> <p>What I would like is, the data broken down to each individual tweet to something like this..</p> <p>[u'Sales at Apple stores have fallen 4.5% per square foot. The search for a new head of retail: <a href="http://t.co/YQ0LQGXfXp">http://t.co/YQ0LQGXfXp</a> $AAPL', </p> <p>u'In rare move, Obama administration vetoes ban on sale of some Apple devices. <a href="http://t.co/UMCTcC1TQu">http://t.co/UMCTcC1TQu</a> $AAPL', </p> <p>u"AT&amp;T claims it's the 1st U.S. store, even before Apple, to do away completely w/o cash registers. <a href="http://t.co/pWmTQCHlBm">http://t.co/pWmTQCHlBm</a> $T @ATT $aapl $VZ", </p> <p>u"Justice Department is seeking oversight over Apple's iTunes store to curb anticompetitive behavior.</p> <p>(I can do without the spaces)</p> <p>Below is the code</p> <pre><code>import simplejson import httplib2 import twitter api = twitter.Api(consumer_key='consumer key', consumer_secret='consumer secret', access_token_key='access token', access_token_secret='access token secret') search = api.GetSearch(term='$aapl', geocode=None, since_id=None, max_id=None, until=None, count=15, lang=None, result_type='mixed', include_entities=None) print [s.text for s in search] </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload