{ "cells": [ { "cell_type": "markdown", "metadata": { "collapsed": true }, "source": [ "# EventVestor: Earnings Guidance\n", "\n", "In this notebook, we'll take a look at EventVestor's *Earnings Guidance* dataset, available on the [Quantopian Store](https://www.quantopian.com/store). This dataset spans January 01, 2007 through the current day, and documents forward looking earnings guidance provided by companies.\n", "\n", "### Blaze\n", "Before we dig into the data, we want to tell you about how you generally access Quantopian Store data sets. These datasets are available through an API service known as [Blaze](http://blaze.pydata.org). Blaze provides the Quantopian user with a convenient interface to access very large datasets.\n", "\n", "Blaze provides an important function for accessing these datasets. Some of these sets are many millions of records. Bringing that data directly into Quantopian Research directly just is not viable. So Blaze allows us to provide a simple querying interface and shift the burden over to the server side.\n", "\n", "It is common to use Blaze to reduce your dataset in size, convert it over to Pandas and then to use Pandas for further computation, manipulation and visualization.\n", "\n", "Helpful links:\n", "* [Query building for Blaze](http://blaze.pydata.org/en/latest/queries.html)\n", "* [Pandas-to-Blaze dictionary](http://blaze.pydata.org/en/latest/rosetta-pandas.html)\n", "* [SQL-to-Blaze dictionary](http://blaze.pydata.org/en/latest/rosetta-sql.html).\n", "\n", "Once you've limited the size of your Blaze object, you can convert it to a Pandas DataFrames using:\n", "> `from odo import odo` \n", "> `odo(expr, pandas.DataFrame)`\n", "\n", "### Free samples and limits\n", "One other key caveat: we limit the number of results returned from any given expression to 10,000 to protect against runaway memory usage. To be clear, you have access to all the data server side. We are limiting the size of the responses back from Blaze.\n", "\n", "There is a *free* version of this dataset as well as a paid one. The free one includes about three years of historical data, though not up to the current day.\n", "\n", "With preamble in place, let's get started:" ] }, { "cell_type": "code", "execution_count": 9, "metadata": { "collapsed": false }, "outputs": [], "source": [ "# import the dataset\n", "from quantopian.interactive.data.eventvestor import earnings_guidance\n", "# or if you want to import the free dataset, use:\n", "# from quantopian.interactive.data.eventvestor import earnings_guidance_free\n", "\n", "# import data operations\n", "from odo import odo\n", "# import other libraries we will use\n", "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 10, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/plain": [ "dshape(\"\"\"var * {\n", " event_id: ?float64,\n", " asof_date: datetime,\n", " trade_date: ?datetime,\n", " symbol: ?string,\n", " event_type: ?string,\n", " event_headline: ?string,\n", " event_phase: ?string,\n", " guidance_content: ?string,\n", " guidance_gaap: ?string,\n", " guidance_trend: ?string,\n", " guidance_quality: ?string,\n", " fiscal_quarter: ?string,\n", " eps_low: ?float64,\n", " eps_high: ?float64,\n", " revenue_low: ?float64,\n", " revenue_high: ?float64,\n", " netincome_low: ?float64,\n", " netincome_high: ?float64,\n", " fiscal_year: ?string,\n", " annual_trend: ?string,\n", " event_rating: ?float64,\n", " timestamp: datetime,\n", " sid: ?int64\n", " }\"\"\")" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Let's use blaze to understand the data a bit using Blaze dshape()\n", "earnings_guidance.dshape" ] }, { "cell_type": "code", "execution_count": 11, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "97769" ], "text/plain": [ "97769" ] }, "execution_count": 11, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# And how many rows are there?\n", "# N.B. we're using a Blaze function to do this, not len()\n", "earnings_guidance.count()" ] }, { "cell_type": "code", "execution_count": 12, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
event_idasof_datetrade_datesymbolevent_typeevent_headlineevent_phaseguidance_contentguidance_gaapguidance_trendguidance_qualityfiscal_quartereps_loweps_highrevenue_lowrevenue_highnetincome_lownetincome_highfiscal_yearannual_trendevent_ratingtimestampsid
09339032007-01-022007-01-02INODGuidanceNumerex Raises 4Q and FY 06 GuidanceNaNOther FinancialGAAPHigherOpen Ended4Q 060.000.000000FY 06Higher12007-01-039581
11383792007-01-022007-01-03SLGGuidanceSL Green Realty Issues FY 07 FFO GuidanceNaNOther FinancialNon-GAAPNaNNaNNaN0.000.000000FY 07New12007-01-0317448
21378092007-01-032007-01-03AEOGuidanceAmerican Eagle Raises 4Q 06 EPS GuidanceNaNEPSGAAPHigherRange4Q 060.640.650000NaNNaN12007-01-0411086
" ], "text/plain": [ " event_id asof_date trade_date symbol event_type \\\n", "0 933903 2007-01-02 2007-01-02 INOD Guidance \n", "1 138379 2007-01-02 2007-01-03 SLG Guidance \n", "2 137809 2007-01-03 2007-01-03 AEO Guidance \n", "\n", " event_headline event_phase guidance_content \\\n", "0 Numerex Raises 4Q and FY 06 Guidance NaN Other Financial \n", "1 SL Green Realty Issues FY 07 FFO Guidance NaN Other Financial \n", "2 American Eagle Raises 4Q 06 EPS Guidance NaN EPS \n", "\n", " guidance_gaap guidance_trend ... eps_high revenue_low revenue_high \\\n", "0 GAAP Higher ... 0.00 0 0 \n", "1 Non-GAAP NaN ... 0.00 0 0 \n", "2 GAAP Higher ... 0.65 0 0 \n", "\n", " netincome_low netincome_high fiscal_year annual_trend event_rating \\\n", "0 0 0 FY 06 Higher 1 \n", "1 0 0 FY 07 New 1 \n", "2 0 0 NaN NaN 1 \n", "\n", " timestamp sid \n", "0 2007-01-03 9581 \n", "1 2007-01-03 17448 \n", "2 2007-01-04 11086 \n", "\n", "[3 rows x 23 columns]" ] }, "execution_count": 12, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# Let's see what the data looks like. We'll grab the first three rows.\n", "earnings_guidance[:3]" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's go over the columns:\n", "- **event_id**: the unique identifier for this event.\n", "- **asof_date**: EventVestor's timestamp of event capture.\n", "- **trade_date**: for event announcements made before trading ends, trade_date is the same as event_date. For announcements issued after market close, trade_date is next market open day.\n", "- **symbol**: stock ticker symbol of the affected company.\n", "- **event_type**: this should always be *Guidance*.\n", "- **event_headline**: a brief description of the event\n", "- **event_phase**: the inclusion of this field is likely an error on the part of the data vendor. We're currently attempting to resolve this.\n", "- **guidance_content**: values include *EPS, EPS & Financial, Operational, Other Financial*\n", "- **guidance_gaap**: values include *GAAP, Non-GAAP*\n", "- **guidance_trend**: values include *Higher, Lower, Narrows, New, Reiterate, Withdrawal*\n", "- **guidance_quality**: values include *Open Ended, Point, Range*\n", "- **fiscal_quarter**: fiscal quarter for which guidance is provided\n", "- **eps_low**: low end of the quarterly EPS guidance\n", "- **eps_high**: high end of the quarterly EPS guidance\n", "- **revenue_low**: low end of the quarterly revenue guidance\n", "- **revenue_high**: high end of the quarterly revenue guidance\n", "- **netincome_low**: low end of the quarterly net income guidance\n", "- **netincome_high**: high end of the quarterly net income guidance\n", "- **fiscal_year**: fiscal year for which the quarterly guidance is provided\n", "- **annual_trend**: the annual guidance trend. Values include *Higher, Lower, Narrows, New, Reiterate, Withdrawal*\n", "- **event_rating**: this is always 1. The meaning of this is uncertain.\n", "- **timestamp**: this is our timestamp on when we registered the data.\n", "- **sid**: the equity's unique identifier. Use this instead of the symbol." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "We've done much of the data processing for you. Fields like `timestamp` and `sid` are standardized across all our Store Datasets, so the datasets are easy to combine. We have standardized the `sid` across all our equity databases.\n", "\n", "We can select columns and rows with ease. Below, we'll fetch all of Apple's entries from 2012." ] }, { "cell_type": "code", "execution_count": 13, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [ { "data": { "text/html": [ "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
event_idasof_datetrade_datesymbolevent_typeevent_headlineevent_phaseguidance_contentguidance_gaapguidance_trendguidance_qualityfiscal_quartereps_loweps_highrevenue_lowrevenue_highnetincome_lownetincome_highfiscal_yearannual_trendevent_ratingtimestampsid
013859262012-01-242012-01-25AAPLGuidanceApple Issues 2Q 12 GuidanceNaNEPS & FinancialGAAPNewPoint2Q 128.508.503250325000NaNNaN12012-01-2524
114211022012-04-242012-04-25AAPLGuidanceApple Issues 3Q 12 GuidanceNaNEPS & FinancialGAAPNewPoint3Q 128.688.68340003400000NaNNaN12012-04-2524
214565012012-07-242012-07-25AAPLGuidanceApple Issues 4Q 12 GuidanceNaNEPS & FinancialGAAPNewPoint4Q 127.657.65340003400000NaNNaN12012-07-2524
314967982012-10-252012-10-26AAPLGuidanceApple Issues 1Q 13 GuidanceNaNEPS & FinancialGAAPNewPoint1Q 1311.7511.755200520000NaNNaN12012-10-2624
" ], "text/plain": [ " event_id asof_date trade_date symbol event_type \\\n", "0 1385926 2012-01-24 2012-01-25 AAPL Guidance \n", "1 1421102 2012-04-24 2012-04-25 AAPL Guidance \n", "2 1456501 2012-07-24 2012-07-25 AAPL Guidance \n", "3 1496798 2012-10-25 2012-10-26 AAPL Guidance \n", "\n", " event_headline event_phase guidance_content guidance_gaap \\\n", "0 Apple Issues 2Q 12 Guidance NaN EPS & Financial GAAP \n", "1 Apple Issues 3Q 12 Guidance NaN EPS & Financial GAAP \n", "2 Apple Issues 4Q 12 Guidance NaN EPS & Financial GAAP \n", "3 Apple Issues 1Q 13 Guidance NaN EPS & Financial GAAP \n", "\n", " guidance_trend ... eps_high revenue_low revenue_high netincome_low \\\n", "0 New ... 8.50 3250 3250 0 \n", "1 New ... 8.68 34000 34000 0 \n", "2 New ... 7.65 34000 34000 0 \n", "3 New ... 11.75 5200 5200 0 \n", "\n", " netincome_high fiscal_year annual_trend event_rating timestamp sid \n", "0 0 NaN NaN 1 2012-01-25 24 \n", "1 0 NaN NaN 1 2012-04-25 24 \n", "2 0 NaN NaN 1 2012-07-25 24 \n", "3 0 NaN NaN 1 2012-10-26 24 \n", "\n", "[4 rows x 23 columns]" ] }, "execution_count": 13, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# get apple's sid first\n", "aapl_sid = symbols('AAPL').sid\n", "aapl_earnings = earnings_guidance[('2011-12-31' < earnings_guidance['asof_date']) & (earnings_guidance['asof_date'] <'2013-01-01') & (earnings_guidance.sid==aapl_sid)]\n", "# When displaying a Blaze Data Object, the printout is automatically truncated to ten rows.\n", "aapl_earnings.sort('asof_date')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Finally, suppose we want a DataFrame of all earnings guidances releases in 2012 in which revenue_low and revenue_high differ. Then we'll compute by how much they differ!" ] }, { "cell_type": "code", "execution_count": 14, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
event_idasof_datetrade_datesymbolevent_typeevent_headlineevent_phaseguidance_contentguidance_gaapguidance_trend...revenue_lowrevenue_highnetincome_lownetincome_highfiscal_yearannual_trendevent_ratingtimestampsidrevenue_difference
019300902012-07-262012-07-26ATEGuidanceAdvantest Corp. Issues 2Q 12 & Narrows FY 12 O...NaNOther FinancialGAAPNew...72000.0077000.000.00.0FY 12Narrows12012-07-27230525000.00
114968432012-10-252012-10-26AMZNGuidanceAmazon.com Issues 4Q 12 GuidanceNaNOther FinancialGAAPNew...20250.0022750.000.00.0NaNNaN12012-10-26168412500.00
214960292012-10-252012-10-25TSMGuidanceTaiwan Semiconductor Issues 4Q 12 GuidanceNaNOther FinancialGAAPNew...129000.00131000.000.00.0NaNNaN12012-10-26177732000.00
314905342012-09-102012-09-10TSMGuidanceTaiwan Semiconductor Raises 3Q 12 GuidanceNaNOther FinancialGAAPHigher...136000.00138000.000.00.0NaNNaN12012-09-11177732000.00
414548392012-07-192012-07-19TSMGuidanceTaiwan Semiconductor Issues 3Q 12 GuidanceNaNOther FinancialGAAPNew...136000.00138000.000.00.0NaNNaN12012-07-20177732000.00
513841542012-01-182012-01-18TSMGuidanceTaiwan Semiconductor Issues 1Q & FY 12 GuidanceNaNOther FinancialGAAPNew...103000.00105000.000.00.0FY 12New12012-01-19177732000.00
614231492012-04-262012-04-26TSMGuidanceTaiwan Semiconductor Issues 2Q & Revises FY 12...NaNOperationalNaNNew...126000.00128000.000.00.0FY 12NaN12012-04-27177732000.00
714197972012-04-202012-04-20INTUGuidanceIntuit Reaffirms 3Q & FY 12 Earnings GuidanceNaNEPS & FinancialGAAPReiterate...0.001950.000.00.0FY 12Reiterate12012-04-2186551950.00
813889742012-01-312012-02-01AMZNGuidanceAmazon Issues 1Q 12 GuidanceNaNOther FinancialGAAPNew...12000.0013400.000.00.0NaNNaN12012-02-01168411400.00
914229592012-04-262012-04-27AMZNGuidanceAmazon.com Issues 2Q 12 GuidanceNaNOther FinancialGAAPNew...11900.0013300.000.00.0NaNNaN12012-04-27168411400.00
1014914112012-10-162012-10-17INTCGuidanceIntel Corp. Issues 4Q and Revises FY 12 GuidanceNaNOther FinancialNon-GAAPNew...13100.0014100.000.00.0FY 12NaN12012-10-1739511000.00
1114533772012-07-172012-07-18INTCGuidanceIntel Corp. Issues 3Q and Lowers FY 12 Revenue...NaNOther FinancialGAAPNew...13800.0014800.000.00.0FY 12Lower12012-07-1839511000.00
1213845512012-01-192012-01-20INTCGuidanceIntel Issues 1Q & FY 12 OutlookNaNOther FinancialGAAPNew...12300.0013300.000.00.0FY 12New12012-01-2039511000.00
1314184882012-04-172012-04-18INTCGuidanceIntel Issues 2Q and Revises FY 12 OutlookNaNOther FinancialGAAPNew...13100.0014100.000.00.0FY 12NaN12012-04-1839511000.00
1414959172012-10-252012-10-25AVTGuidanceAvnet Issues 2Q 13 GuidanceNaNEPS & FinancialNon-GAAPNew...5950.006650.000.00.0NaNNaN12012-10-26661700.00
1513870092012-01-262012-01-26AVTGuidanceAvnet Issues 3Q 12 GuidanceNaNEPS & FinancialNon-GAAPNew...5950.006550.000.00.0NaNNaN12012-01-27661600.00
1614670542012-08-082012-08-08AVTGuidanceAvnet Issues 1Q 13 GuidanceNaNEPS & FinancialNon-GAAPNew...5800.006400.000.00.0NaNNaN12012-08-09661600.00
1714224632012-04-262012-04-26AVTGuidanceAvnet Issues 4Q 12 GuidanceNaNEPS & FinancialNon-GAAPNew...6300.006900.000.00.0NaNNaN12012-04-27661600.00
1814596612012-07-302012-07-30ARWGuidanceArrow Electronics Issues 3Q 12 GuidanceNaNEPS & FinancialNon-GAAPNew...4800.005200.000.00.03Q 12NaN12012-07-31538400.00
1914927092012-10-182012-10-19FLEXGuidanceFlextronics International Issues 3Q 13 GuidanceNaNEPS & FinancialGAAPNew...5800.006200.000.00.0NaNNaN12012-10-1910953400.00
2013893932012-02-012012-02-01ARWGuidanceArrow Electronics Issues 1Q 12 GuidanceNaNEPS & FinancialNon-GAAPNew...4670.005070.000.00.0NaNNaN12012-02-02538400.00
2114249092012-05-012012-05-01ARWGuidanceArrow Electronics Issues 2Q 12 GuidanceNaNEPS & FinancialNon-GAAPNew...5040.005440.000.00.0NaNNaN12012-05-02538400.00
2214188642012-04-182012-04-19QCOMGuidanceQualcomm Issues 3Q & Raises FY 12 GuidanceNaNEPS & FinancialGAAPNew...4450.004850.000.00.0FY 12Higher12012-04-196295400.00
2314540392012-07-182012-07-19QCOMGuidanceQualcomm Issues 4Q and Lowers FY 12 GuidanceNaNEPS & FinancialGAAPNew...4450.004850.000.00.0FY 12Lower12012-07-196295400.00
2414573952012-07-252012-07-26FLEXGuidanceFlextronics International Issues 2Q 13 GuidanceNaNEPS & FinancialGAAPNew...5900.006300.000.00.0NaNNaN12012-07-2610953400.00
2514254872012-05-012012-05-02FLEXGuidanceFlextronics International Issues 1Q 13 GuidanceNaNEPS & FinancialGAAPNew...5900.006300.000.00.0NaNNaN12012-05-0210953400.00
2613896262012-02-012012-02-02QCOMGuidanceQualcomm Issues 2Q and Raises FY 12 GuidanceNaNEPS & FinancialGAAPNew...4600.005000.000.00.0FY 12Higher12012-02-026295400.00
2713803152012-01-042012-01-05STXGuidanceSeagate Technology Raises 3Q 12 OutlookNaNOther FinancialNon-GAAPHigher...4200.004500.000.00.0NaNNaN12012-01-0524518300.00
2813846352012-01-192012-01-20FLEXGuidanceFlextronics Issues 4Q 12 GuidanceNaNEPS & FinancialGAAPNew...6300.006600.000.00.0NaNNaN12012-01-2010953300.00
2914196322012-04-192012-04-19CVIGuidanceCVR Energy Issues 1Q 12 GuidanceNaNOther FinancialGAAPNew...1800.002100.000.00.0NaNNaN12012-04-2022766300.00
..................................................................
159913986112012-02-212012-02-22ZIXIGuidanceZix Corp. Issues 1Q and FY 12 GuidanceNaNEPS & FinancialNon-GAAPNew...10.0010.100.00.0FY 12New12012-02-22208220.10
160014033412012-02-292012-03-01MTZGuidanceMasTec Issues 1Q and FY 12 OutlookNaNEPS & FinancialGAAPNew...0.150.1712.314.1FY 12New12012-03-0146670.02
160113872982012-01-262012-01-27CYSGuidanceCYS Investments Issues 4Q 11 GuidanceNaNEPSGAAPNew...0.550.000.00.0NaNNaN12012-01-2738477-0.55
160214395052012-02-142012-02-14KORSGuidanceMichael Kors Holdings Issues 4Q & FY 12 GuidanceNaNEPS & FinancialGAAPNew...350.00335.000.00.0FY 12New12012-02-1542270-15.00
160314246172012-04-262012-04-26INODGuidanceInnodata Isogen Issues 2Q 12 Revenue GuidanceNaNOther FinancialGAAPNew...21.000.000.00.0NaNNaN12012-04-279581-21.00
160413822942012-01-112012-01-11SAASGuidanceinContact Issues 4Q 11 GuidanceNaNOther FinancialGAAPNew...23.500.000.00.0NaNNaN12012-01-1231137-23.50
160514413242012-06-062012-06-06AMSCGuidanceAmerican Superconductor Issues 1Q 12 GuidanceNaNEPS & FinancialGAAPNew...26.000.000.010.0NaNNaN12012-06-07393-26.00
160613932522012-02-092012-02-09AMSCGuidanceAmerican Superconductor Updates 4Q 11 OutlookNaNEPS & FinancialGAAPNaN...27.000.00-24.00.0NaNNaN12012-02-10393-27.00
160713916212012-02-062012-02-07BDEGuidanceBlack Diamond Issues 4Q and Raises FY 11 GuidanceNaNEPS & FinancialGAAPNew...36.000.000.00.0FY 11Higher12012-02-0718803-36.00
160815443062012-06-042012-06-04CALLGuidancemagicJack VocalTec Issues 2Q and Raises FY 12 ...NaNEPS & FinancialGAAPNew...36.000.000.00.0FY 12Higher12012-06-0514457-36.00
160914111222012-03-202012-03-21FSIIGuidanceFSI International Issues 3Q 12 GuidanceNaNOther FinancialGAAPNew...50.000.007.09.0NaNNaN12012-03-213029-50.00
161014120142012-03-232012-03-23KITDGuidanceKIT digital Reaffirms 1Q and FY 12 GuidanceNaNEPS & FinancialNon-GAAPReiterate...72.000.000.00.0FY 12Reiterate12012-03-2430692-72.00
161114019032012-02-272012-02-28KITDGuidanceKIT digital Issues 1Q and Lowers FY 12 GuidanceNaNEPS & FinancialNon-GAAPNew...72.000.000.00.0FY 12Lower12012-02-2830692-72.00
161214097262012-03-152012-03-15KITDGuidanceKIT digital Reaffirms 1Q and FY 12 GuidanceNaNEPS & FinancialNon-GAAPReiterate...72.000.000.00.0FY 12Reiterate12012-03-1630692-72.00
161314900362012-10-112012-10-12ETGuidanceExactTarget Raises 3Q 12 GuidanceNaNOther FinancialNon-GAAPHigher...72.000.00-3.00.0NaNNaN12012-10-1242700-72.00
161413911962012-02-022012-02-02FTKGuidanceFlotek Industries Issues 4Q and FY 11 GuidanceNaNOther FinancialGAAPNew...74.500.000.00.0FY 11New12012-02-0327496-74.50
161514179092012-04-162012-04-16FTKGuidanceFlotek Industries Raises 1Q 12 Revenues GuidanceNaNOther FinancialGAAPNew...78.000.000.00.0NaNNaN12012-04-1727496-78.00
161614377952012-01-242012-01-24FIOGuidanceFusion-io Issues 3Q & Raises FY 12 GuidanceNaNOther FinancialNon-GAAPNew...85.000.000.00.0FY 12Higher12012-01-2541554-85.00
161714438982012-05-142012-05-14MPAAGuidanceMotorcar Parts of America Issues 4Q and FY 12 ...NaNOther FinancialGAAPNew...90.000.000.00.0FY 12New12012-05-1510992-90.00
161814002392012-02-232012-02-24WBMDGuidanceWebMD Health Issues 1Q and Updates FY 12 GuidanceNaNOther FinancialNon-GAAPNew...105.000.000.00.0FY 12NaN12012-02-2427669-105.00
161914575052012-07-252012-07-26CVDGuidanceCovance Issues 3Q and Lowers FY 12 GuidanceNaNEPS & FinancialNon-GAAPNew...538.000.000.00.0FY 12Lower12012-07-2625396-538.00
162014865882012-01-062012-01-06VRXGuidanceValeant Pharmaceuticals Issues 4Q and Updates ...NaNEPS & FinancialNon-GAAPNew...650.000.000.00.0FY 11NaN12012-01-0710908-650.00
162114168532012-04-112012-04-11VMWGuidanceVMware Raises 1Q 12 GuidanceNaNOther FinancialGAAPHigher...1040.000.000.00.0NaNNaN12012-04-1234545-1040.00
162213924732012-02-082012-02-08CTSHGuidanceCognizant Technology Solutions Issues 1Q and F...NaNEPS & FinancialGAAPNew...1700.000.000.00.0FY 12New12012-02-0918870-1700.00
162314288892012-05-072012-05-07CTSHGuidanceCognizant Technology Solutions Issues 2Q and L...NaNEPS & FinancialGAAPNew...1790.000.000.00.0FY 12Lower12012-05-0818870-1790.00
162414646922012-08-062012-08-06CTSHGuidanceCognizant Technology Solutions Issues 3Q and R...NaNEPS & FinancialGAAPNew...1875.000.000.00.0FY 12Higher12012-08-0718870-1875.00
162513889932012-01-312012-02-01STXGuidanceSeagate Technology Raises 3Q 12 OutlookNaNOther FinancialGAAPHigher...4300.000.000.00.0NaNNaN12012-02-0124518-4300.00
162614220452012-04-262012-04-26TYCGuidanceTyco International Issues 3Q and Raises FY 12 ...NaNEPS & FinancialNon-GAAPNew...4500.000.000.00.0FY 12Higher12012-04-277679-4500.00
162714330722012-04-172012-04-17STXGuidanceSeagate Technology Updates 4Q 12 and Calendar ...NaNOther FinancialNon-GAAPNaN...5000.000.000.00.0NaNNaN12012-04-1824518-5000.00
162813891652012-01-312012-02-01STXGuidanceSeagate Technology Issues 4Q 12 OutlookNaNOther FinancialGAAPNew...5000.000.000.00.0NaNNaN12012-02-0124518-5000.00
\n", "

1629 rows × 24 columns

\n", "
" ], "text/plain": [ " event_id asof_date trade_date symbol event_type \\\n", "0 1930090 2012-07-26 2012-07-26 ATE Guidance \n", "1 1496843 2012-10-25 2012-10-26 AMZN Guidance \n", "2 1496029 2012-10-25 2012-10-25 TSM Guidance \n", "3 1490534 2012-09-10 2012-09-10 TSM Guidance \n", "4 1454839 2012-07-19 2012-07-19 TSM Guidance \n", "5 1384154 2012-01-18 2012-01-18 TSM Guidance \n", "6 1423149 2012-04-26 2012-04-26 TSM Guidance \n", "7 1419797 2012-04-20 2012-04-20 INTU Guidance \n", "8 1388974 2012-01-31 2012-02-01 AMZN Guidance \n", "9 1422959 2012-04-26 2012-04-27 AMZN Guidance \n", "10 1491411 2012-10-16 2012-10-17 INTC Guidance \n", "11 1453377 2012-07-17 2012-07-18 INTC Guidance \n", "12 1384551 2012-01-19 2012-01-20 INTC Guidance \n", "13 1418488 2012-04-17 2012-04-18 INTC Guidance \n", "14 1495917 2012-10-25 2012-10-25 AVT Guidance \n", "15 1387009 2012-01-26 2012-01-26 AVT Guidance \n", "16 1467054 2012-08-08 2012-08-08 AVT Guidance \n", "17 1422463 2012-04-26 2012-04-26 AVT Guidance \n", "18 1459661 2012-07-30 2012-07-30 ARW Guidance \n", "19 1492709 2012-10-18 2012-10-19 FLEX Guidance \n", "20 1389393 2012-02-01 2012-02-01 ARW Guidance \n", "21 1424909 2012-05-01 2012-05-01 ARW Guidance \n", "22 1418864 2012-04-18 2012-04-19 QCOM Guidance \n", "23 1454039 2012-07-18 2012-07-19 QCOM Guidance \n", "24 1457395 2012-07-25 2012-07-26 FLEX Guidance \n", "25 1425487 2012-05-01 2012-05-02 FLEX Guidance \n", "26 1389626 2012-02-01 2012-02-02 QCOM Guidance \n", "27 1380315 2012-01-04 2012-01-05 STX Guidance \n", "28 1384635 2012-01-19 2012-01-20 FLEX Guidance \n", "29 1419632 2012-04-19 2012-04-19 CVI Guidance \n", "... ... ... ... ... ... \n", "1599 1398611 2012-02-21 2012-02-22 ZIXI Guidance \n", "1600 1403341 2012-02-29 2012-03-01 MTZ Guidance \n", "1601 1387298 2012-01-26 2012-01-27 CYS Guidance \n", "1602 1439505 2012-02-14 2012-02-14 KORS Guidance \n", "1603 1424617 2012-04-26 2012-04-26 INOD Guidance \n", "1604 1382294 2012-01-11 2012-01-11 SAAS Guidance \n", "1605 1441324 2012-06-06 2012-06-06 AMSC Guidance \n", "1606 1393252 2012-02-09 2012-02-09 AMSC Guidance \n", "1607 1391621 2012-02-06 2012-02-07 BDE Guidance \n", "1608 1544306 2012-06-04 2012-06-04 CALL Guidance \n", "1609 1411122 2012-03-20 2012-03-21 FSII Guidance \n", "1610 1412014 2012-03-23 2012-03-23 KITD Guidance \n", "1611 1401903 2012-02-27 2012-02-28 KITD Guidance \n", "1612 1409726 2012-03-15 2012-03-15 KITD Guidance \n", "1613 1490036 2012-10-11 2012-10-12 ET Guidance \n", "1614 1391196 2012-02-02 2012-02-02 FTK Guidance \n", "1615 1417909 2012-04-16 2012-04-16 FTK Guidance \n", "1616 1437795 2012-01-24 2012-01-24 FIO Guidance \n", "1617 1443898 2012-05-14 2012-05-14 MPAA Guidance \n", "1618 1400239 2012-02-23 2012-02-24 WBMD Guidance \n", "1619 1457505 2012-07-25 2012-07-26 CVD Guidance \n", "1620 1486588 2012-01-06 2012-01-06 VRX Guidance \n", "1621 1416853 2012-04-11 2012-04-11 VMW Guidance \n", "1622 1392473 2012-02-08 2012-02-08 CTSH Guidance \n", "1623 1428889 2012-05-07 2012-05-07 CTSH Guidance \n", "1624 1464692 2012-08-06 2012-08-06 CTSH Guidance \n", "1625 1388993 2012-01-31 2012-02-01 STX Guidance \n", "1626 1422045 2012-04-26 2012-04-26 TYC Guidance \n", "1627 1433072 2012-04-17 2012-04-17 STX Guidance \n", "1628 1389165 2012-01-31 2012-02-01 STX Guidance \n", "\n", " event_headline event_phase \\\n", "0 Advantest Corp. Issues 2Q 12 & Narrows FY 12 O... NaN \n", "1 Amazon.com Issues 4Q 12 Guidance NaN \n", "2 Taiwan Semiconductor Issues 4Q 12 Guidance NaN \n", "3 Taiwan Semiconductor Raises 3Q 12 Guidance NaN \n", "4 Taiwan Semiconductor Issues 3Q 12 Guidance NaN \n", "5 Taiwan Semiconductor Issues 1Q & FY 12 Guidance NaN \n", "6 Taiwan Semiconductor Issues 2Q & Revises FY 12... NaN \n", "7 Intuit Reaffirms 3Q & FY 12 Earnings Guidance NaN \n", "8 Amazon Issues 1Q 12 Guidance NaN \n", "9 Amazon.com Issues 2Q 12 Guidance NaN \n", "10 Intel Corp. Issues 4Q and Revises FY 12 Guidance NaN \n", "11 Intel Corp. Issues 3Q and Lowers FY 12 Revenue... NaN \n", "12 Intel Issues 1Q & FY 12 Outlook NaN \n", "13 Intel Issues 2Q and Revises FY 12 Outlook NaN \n", "14 Avnet Issues 2Q 13 Guidance NaN \n", "15 Avnet Issues 3Q 12 Guidance NaN \n", "16 Avnet Issues 1Q 13 Guidance NaN \n", "17 Avnet Issues 4Q 12 Guidance NaN \n", "18 Arrow Electronics Issues 3Q 12 Guidance NaN \n", "19 Flextronics International Issues 3Q 13 Guidance NaN \n", "20 Arrow Electronics Issues 1Q 12 Guidance NaN \n", "21 Arrow Electronics Issues 2Q 12 Guidance NaN \n", "22 Qualcomm Issues 3Q & Raises FY 12 Guidance NaN \n", "23 Qualcomm Issues 4Q and Lowers FY 12 Guidance NaN \n", "24 Flextronics International Issues 2Q 13 Guidance NaN \n", "25 Flextronics International Issues 1Q 13 Guidance NaN \n", "26 Qualcomm Issues 2Q and Raises FY 12 Guidance NaN \n", "27 Seagate Technology Raises 3Q 12 Outlook NaN \n", "28 Flextronics Issues 4Q 12 Guidance NaN \n", "29 CVR Energy Issues 1Q 12 Guidance NaN \n", "... ... ... \n", "1599 Zix Corp. Issues 1Q and FY 12 Guidance NaN \n", "1600 MasTec Issues 1Q and FY 12 Outlook NaN \n", "1601 CYS Investments Issues 4Q 11 Guidance NaN \n", "1602 Michael Kors Holdings Issues 4Q & FY 12 Guidance NaN \n", "1603 Innodata Isogen Issues 2Q 12 Revenue Guidance NaN \n", "1604 inContact Issues 4Q 11 Guidance NaN \n", "1605 American Superconductor Issues 1Q 12 Guidance NaN \n", "1606 American Superconductor Updates 4Q 11 Outlook NaN \n", "1607 Black Diamond Issues 4Q and Raises FY 11 Guidance NaN \n", "1608 magicJack VocalTec Issues 2Q and Raises FY 12 ... NaN \n", "1609 FSI International Issues 3Q 12 Guidance NaN \n", "1610 KIT digital Reaffirms 1Q and FY 12 Guidance NaN \n", "1611 KIT digital Issues 1Q and Lowers FY 12 Guidance NaN \n", "1612 KIT digital Reaffirms 1Q and FY 12 Guidance NaN \n", "1613 ExactTarget Raises 3Q 12 Guidance NaN \n", "1614 Flotek Industries Issues 4Q and FY 11 Guidance NaN \n", "1615 Flotek Industries Raises 1Q 12 Revenues Guidance NaN \n", "1616 Fusion-io Issues 3Q & Raises FY 12 Guidance NaN \n", "1617 Motorcar Parts of America Issues 4Q and FY 12 ... NaN \n", "1618 WebMD Health Issues 1Q and Updates FY 12 Guidance NaN \n", "1619 Covance Issues 3Q and Lowers FY 12 Guidance NaN \n", "1620 Valeant Pharmaceuticals Issues 4Q and Updates ... NaN \n", "1621 VMware Raises 1Q 12 Guidance NaN \n", "1622 Cognizant Technology Solutions Issues 1Q and F... NaN \n", "1623 Cognizant Technology Solutions Issues 2Q and L... NaN \n", "1624 Cognizant Technology Solutions Issues 3Q and R... NaN \n", "1625 Seagate Technology Raises 3Q 12 Outlook NaN \n", "1626 Tyco International Issues 3Q and Raises FY 12 ... NaN \n", "1627 Seagate Technology Updates 4Q 12 and Calendar ... NaN \n", "1628 Seagate Technology Issues 4Q 12 Outlook NaN \n", "\n", " guidance_content guidance_gaap guidance_trend ... \\\n", "0 Other Financial GAAP New ... \n", "1 Other Financial GAAP New ... \n", "2 Other Financial GAAP New ... \n", "3 Other Financial GAAP Higher ... \n", "4 Other Financial GAAP New ... \n", "5 Other Financial GAAP New ... \n", "6 Operational NaN New ... \n", "7 EPS & Financial GAAP Reiterate ... \n", "8 Other Financial GAAP New ... \n", "9 Other Financial GAAP New ... \n", "10 Other Financial Non-GAAP New ... \n", "11 Other Financial GAAP New ... \n", "12 Other Financial GAAP New ... \n", "13 Other Financial GAAP New ... \n", "14 EPS & Financial Non-GAAP New ... \n", "15 EPS & Financial Non-GAAP New ... \n", "16 EPS & Financial Non-GAAP New ... \n", "17 EPS & Financial Non-GAAP New ... \n", "18 EPS & Financial Non-GAAP New ... \n", "19 EPS & Financial GAAP New ... \n", "20 EPS & Financial Non-GAAP New ... \n", "21 EPS & Financial Non-GAAP New ... \n", "22 EPS & Financial GAAP New ... \n", "23 EPS & Financial GAAP New ... \n", "24 EPS & Financial GAAP New ... \n", "25 EPS & Financial GAAP New ... \n", "26 EPS & Financial GAAP New ... \n", "27 Other Financial Non-GAAP Higher ... \n", "28 EPS & Financial GAAP New ... \n", "29 Other Financial GAAP New ... \n", "... ... ... ... ... \n", "1599 EPS & Financial Non-GAAP New ... \n", "1600 EPS & Financial GAAP New ... \n", "1601 EPS GAAP New ... \n", "1602 EPS & Financial GAAP New ... \n", "1603 Other Financial GAAP New ... \n", "1604 Other Financial GAAP New ... \n", "1605 EPS & Financial GAAP New ... \n", "1606 EPS & Financial GAAP NaN ... \n", "1607 EPS & Financial GAAP New ... \n", "1608 EPS & Financial GAAP New ... \n", "1609 Other Financial GAAP New ... \n", "1610 EPS & Financial Non-GAAP Reiterate ... \n", "1611 EPS & Financial Non-GAAP New ... \n", "1612 EPS & Financial Non-GAAP Reiterate ... \n", "1613 Other Financial Non-GAAP Higher ... \n", "1614 Other Financial GAAP New ... \n", "1615 Other Financial GAAP New ... \n", "1616 Other Financial Non-GAAP New ... \n", "1617 Other Financial GAAP New ... \n", "1618 Other Financial Non-GAAP New ... \n", "1619 EPS & Financial Non-GAAP New ... \n", "1620 EPS & Financial Non-GAAP New ... \n", "1621 Other Financial GAAP Higher ... \n", "1622 EPS & Financial GAAP New ... \n", "1623 EPS & Financial GAAP New ... \n", "1624 EPS & Financial GAAP New ... \n", "1625 Other Financial GAAP Higher ... \n", "1626 EPS & Financial Non-GAAP New ... \n", "1627 Other Financial Non-GAAP NaN ... \n", "1628 Other Financial GAAP New ... \n", "\n", " revenue_low revenue_high netincome_low netincome_high fiscal_year \\\n", "0 72000.00 77000.00 0.0 0.0 FY 12 \n", "1 20250.00 22750.00 0.0 0.0 NaN \n", "2 129000.00 131000.00 0.0 0.0 NaN \n", "3 136000.00 138000.00 0.0 0.0 NaN \n", "4 136000.00 138000.00 0.0 0.0 NaN \n", "5 103000.00 105000.00 0.0 0.0 FY 12 \n", "6 126000.00 128000.00 0.0 0.0 FY 12 \n", "7 0.00 1950.00 0.0 0.0 FY 12 \n", "8 12000.00 13400.00 0.0 0.0 NaN \n", "9 11900.00 13300.00 0.0 0.0 NaN \n", "10 13100.00 14100.00 0.0 0.0 FY 12 \n", "11 13800.00 14800.00 0.0 0.0 FY 12 \n", "12 12300.00 13300.00 0.0 0.0 FY 12 \n", "13 13100.00 14100.00 0.0 0.0 FY 12 \n", "14 5950.00 6650.00 0.0 0.0 NaN \n", "15 5950.00 6550.00 0.0 0.0 NaN \n", "16 5800.00 6400.00 0.0 0.0 NaN \n", "17 6300.00 6900.00 0.0 0.0 NaN \n", "18 4800.00 5200.00 0.0 0.0 3Q 12 \n", "19 5800.00 6200.00 0.0 0.0 NaN \n", "20 4670.00 5070.00 0.0 0.0 NaN \n", "21 5040.00 5440.00 0.0 0.0 NaN \n", "22 4450.00 4850.00 0.0 0.0 FY 12 \n", "23 4450.00 4850.00 0.0 0.0 FY 12 \n", "24 5900.00 6300.00 0.0 0.0 NaN \n", "25 5900.00 6300.00 0.0 0.0 NaN \n", "26 4600.00 5000.00 0.0 0.0 FY 12 \n", "27 4200.00 4500.00 0.0 0.0 NaN \n", "28 6300.00 6600.00 0.0 0.0 NaN \n", "29 1800.00 2100.00 0.0 0.0 NaN \n", "... ... ... ... ... ... \n", "1599 10.00 10.10 0.0 0.0 FY 12 \n", "1600 0.15 0.17 12.3 14.1 FY 12 \n", "1601 0.55 0.00 0.0 0.0 NaN \n", "1602 350.00 335.00 0.0 0.0 FY 12 \n", "1603 21.00 0.00 0.0 0.0 NaN \n", "1604 23.50 0.00 0.0 0.0 NaN \n", "1605 26.00 0.00 0.0 10.0 NaN \n", "1606 27.00 0.00 -24.0 0.0 NaN \n", "1607 36.00 0.00 0.0 0.0 FY 11 \n", "1608 36.00 0.00 0.0 0.0 FY 12 \n", "1609 50.00 0.00 7.0 9.0 NaN \n", "1610 72.00 0.00 0.0 0.0 FY 12 \n", "1611 72.00 0.00 0.0 0.0 FY 12 \n", "1612 72.00 0.00 0.0 0.0 FY 12 \n", "1613 72.00 0.00 -3.0 0.0 NaN \n", "1614 74.50 0.00 0.0 0.0 FY 11 \n", "1615 78.00 0.00 0.0 0.0 NaN \n", "1616 85.00 0.00 0.0 0.0 FY 12 \n", "1617 90.00 0.00 0.0 0.0 FY 12 \n", "1618 105.00 0.00 0.0 0.0 FY 12 \n", "1619 538.00 0.00 0.0 0.0 FY 12 \n", "1620 650.00 0.00 0.0 0.0 FY 11 \n", "1621 1040.00 0.00 0.0 0.0 NaN \n", "1622 1700.00 0.00 0.0 0.0 FY 12 \n", "1623 1790.00 0.00 0.0 0.0 FY 12 \n", "1624 1875.00 0.00 0.0 0.0 FY 12 \n", "1625 4300.00 0.00 0.0 0.0 NaN \n", "1626 4500.00 0.00 0.0 0.0 FY 12 \n", "1627 5000.00 0.00 0.0 0.0 NaN \n", "1628 5000.00 0.00 0.0 0.0 NaN \n", "\n", " annual_trend event_rating timestamp sid revenue_difference \n", "0 Narrows 1 2012-07-27 23052 5000.00 \n", "1 NaN 1 2012-10-26 16841 2500.00 \n", "2 NaN 1 2012-10-26 17773 2000.00 \n", "3 NaN 1 2012-09-11 17773 2000.00 \n", "4 NaN 1 2012-07-20 17773 2000.00 \n", "5 New 1 2012-01-19 17773 2000.00 \n", "6 NaN 1 2012-04-27 17773 2000.00 \n", "7 Reiterate 1 2012-04-21 8655 1950.00 \n", "8 NaN 1 2012-02-01 16841 1400.00 \n", "9 NaN 1 2012-04-27 16841 1400.00 \n", "10 NaN 1 2012-10-17 3951 1000.00 \n", "11 Lower 1 2012-07-18 3951 1000.00 \n", "12 New 1 2012-01-20 3951 1000.00 \n", "13 NaN 1 2012-04-18 3951 1000.00 \n", "14 NaN 1 2012-10-26 661 700.00 \n", "15 NaN 1 2012-01-27 661 600.00 \n", "16 NaN 1 2012-08-09 661 600.00 \n", "17 NaN 1 2012-04-27 661 600.00 \n", "18 NaN 1 2012-07-31 538 400.00 \n", "19 NaN 1 2012-10-19 10953 400.00 \n", "20 NaN 1 2012-02-02 538 400.00 \n", "21 NaN 1 2012-05-02 538 400.00 \n", "22 Higher 1 2012-04-19 6295 400.00 \n", "23 Lower 1 2012-07-19 6295 400.00 \n", "24 NaN 1 2012-07-26 10953 400.00 \n", "25 NaN 1 2012-05-02 10953 400.00 \n", "26 Higher 1 2012-02-02 6295 400.00 \n", "27 NaN 1 2012-01-05 24518 300.00 \n", "28 NaN 1 2012-01-20 10953 300.00 \n", "29 NaN 1 2012-04-20 22766 300.00 \n", "... ... ... ... ... ... \n", "1599 New 1 2012-02-22 20822 0.10 \n", "1600 New 1 2012-03-01 4667 0.02 \n", "1601 NaN 1 2012-01-27 38477 -0.55 \n", "1602 New 1 2012-02-15 42270 -15.00 \n", "1603 NaN 1 2012-04-27 9581 -21.00 \n", "1604 NaN 1 2012-01-12 31137 -23.50 \n", "1605 NaN 1 2012-06-07 393 -26.00 \n", "1606 NaN 1 2012-02-10 393 -27.00 \n", "1607 Higher 1 2012-02-07 18803 -36.00 \n", "1608 Higher 1 2012-06-05 14457 -36.00 \n", "1609 NaN 1 2012-03-21 3029 -50.00 \n", "1610 Reiterate 1 2012-03-24 30692 -72.00 \n", "1611 Lower 1 2012-02-28 30692 -72.00 \n", "1612 Reiterate 1 2012-03-16 30692 -72.00 \n", "1613 NaN 1 2012-10-12 42700 -72.00 \n", "1614 New 1 2012-02-03 27496 -74.50 \n", "1615 NaN 1 2012-04-17 27496 -78.00 \n", "1616 Higher 1 2012-01-25 41554 -85.00 \n", "1617 New 1 2012-05-15 10992 -90.00 \n", "1618 NaN 1 2012-02-24 27669 -105.00 \n", "1619 Lower 1 2012-07-26 25396 -538.00 \n", "1620 NaN 1 2012-01-07 10908 -650.00 \n", "1621 NaN 1 2012-04-12 34545 -1040.00 \n", "1622 New 1 2012-02-09 18870 -1700.00 \n", "1623 Lower 1 2012-05-08 18870 -1790.00 \n", "1624 Higher 1 2012-08-07 18870 -1875.00 \n", "1625 NaN 1 2012-02-01 24518 -4300.00 \n", "1626 Higher 1 2012-04-27 7679 -4500.00 \n", "1627 NaN 1 2012-04-18 24518 -5000.00 \n", "1628 NaN 1 2012-02-01 24518 -5000.00 \n", "\n", "[1629 rows x 24 columns]" ] }, "execution_count": 14, "metadata": {}, "output_type": "execute_result" } ], "source": [ "# manipulate with Blaze first:\n", "twentytwelve = earnings_guidance[(earnings_guidance['asof_date'] < '2012-12-31')&('2012-01-01' <= earnings_guidance['asof_date'])]\n", "# now that we've got a much smaller object (len: ~39000 rows), we can convert it to a pandas DataFrame\n", "df = odo(twentytwelve, pd.DataFrame)\n", "df = df[df.revenue_low != df.revenue_high]\n", "df['revenue_difference'] = df.revenue_high - df.revenue_low\n", "df.sort('revenue_difference', ascending=False, inplace=True)\n", "df.index = range(len(df))\n", "# When printed: pandas DataFrames display the head(30) and tail(30) rows, and truncate the middle.\n", "df" ] }, { "cell_type": "code", "execution_count": null, "metadata": { "collapsed": true }, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 2", "language": "python", "name": "python2" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 2 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython2", "version": "2.7.10" } }, "nbformat": 4, "nbformat_minor": 0 }