PivotTables in Google Spreadsheets. Pivot tables

    Today, the Google Docs team announced the release of an important addition to Spreadsheets, a pivot table tool. Official information includes a video and a link to an example (it didn’t open for me).

    In the wake of it, I tried to use this feature to automatically compose updated data. In my example, this is radiation observation data in the Fukushima area.


    Testing results pleased. We can now not only connect to the updated data stream, but also regroup it.
    1. Connect to the data stream (in my case, a CSV file) using the function = importData ("...") .
    2. The data source turned out to be non-standard, so I had to carry out additional data decomposition in separate cells using the explicit delimiter = SPLIT (A1; char (09)) . The result is a table in which data for several observation periods are in one column .
    3. Now create a Pivot table using Menu> Data> Pivot table report.
    The parameters in my case were:
    Range Results! A1: E901
    Rows Group by station_id
    Columns Group by datetime_utc
    Values ​​Display sa
    And added a filter by empty values.
    The result is a pivot tablein which data are already grouped by series of observations.
    4. Added graphics to the resulting pivot table, posted on the blog .

    conclusions


    The new pivot table tool has worked well.
    In addition to standard office features, it allows you to work with updated data by automatically recounting the table columns and attached graphics.

    Also popular now: