Documentation

Summarize query results and data distribution

Query data stored in InfluxDB and use tools like pandas to summarize the results schema and distribution.

Sample data

The following examples use the sample data written in the Get started writing data guide. To run the example queries and return results, write the sample data to your InfluxDB Cloud Dedicated database before running the example queries.

View data information and statistics

Using Python and pandas

The following example uses the InfluxDB client library for Python to query an InfluxDB Cloud Dedicated database, and then uses pandas DataFrame.info() and DataFrame.describe() methods to summarize the schema and distribution of the data.

  1. In your editor, create a file (for example, pandas-example.py) and enter the following sample code:

    # pandas-example.py
    
    import influxdb_client_3 as InfluxDBClient3
    import pandas
    
    client = InfluxDBClient3.InfluxDBClient3(token='
    DATABASE_TOKEN
    '
    ,
    host='cluster-id.influxdb.io', database='
    DATABASE_NAME
    '
    ,
    org="", write_options=SYNCHRONOUS) table = client.query("select * from home where room like '%'") dataframe = table.to_pandas() # Print information about the results DataFrame, # including the index dtype and columns, non-null values, and memory usage. dataframe.info() # Calculate descriptive statistics that summarize the distribution of the results. print(dataframe.describe())
  2. Enter the following command in your terminal to execute the file using the Python interpreter:

    python pandas-example.py
    

    The output is similar to the following:

    <class 'pandas.core.frame.DataFrame'>
    RangeIndex: 411 entries, 0 to 410
    Data columns (total 8 columns):
    #   Column     Non-Null Count  Dtype         
    ---  ------     --------------  -----         
    0   co         405 non-null    float64       
    1   host       2 non-null      object        
    2   hum        406 non-null    float64       
    3   room       411 non-null    object        
    4   sensor     1 non-null      object        
    5   sensor_id  2 non-null      object        
    6   temp       411 non-null    float64       
    7   time       411 non-null    datetime64[ns]
    dtypes: datetime64[ns](1), float64(3), object(4)
    memory usage: 25.8+ KB
    
                  co         hum        temp                           time
    count  405.000000  406.000000  411.000000                            411
    mean     5.320988   35.860591   23.803893  2008-06-12 13:33:49.074302208
    min      0.000000   20.200000   18.400000     1970-01-01 00:00:01.641024
    25%      0.000000   35.900000   22.200000  1970-01-01 00:00:01.685054600
    50%      1.000000   36.000000   22.500000            2023-03-21 05:46:40
    75%      9.000000   36.300000   22.800000            2023-07-15 21:34:10
    max     26.000000   80.000000   74.000000            2023-07-17 02:07:00
    std      7.640154    3.318794    8.408807                            NaN
    

Was this page helpful?

Thank you for your feedback!


Introducing InfluxDB Clustered

A highly available InfluxDB 3.0 cluster on your own infrastructure.

InfluxDB Clustered is a highly available InfluxDB 3.0 cluster built for high write and query workloads on your own infrastructure.

InfluxDB Clustered is currently in limited availability and is only available to a limited group of InfluxData customers. If interested in being part of the limited access group, please contact the InfluxData Sales team.

Learn more
Contact InfluxData Sales

The future of Flux

Flux is going into maintenance mode. You can continue using it as you currently are without any changes to your code.

Flux is going into maintenance mode and will not be supported in InfluxDB 3.0. This was a decision based on the broad demand for SQL and the continued growth and adoption of InfluxQL. We are continuing to support Flux for users in 1.x and 2.x so you can continue using it with no changes to your code. If you are interested in transitioning to InfluxDB 3.0 and want to future-proof your code, we suggest using InfluxQL.

For information about the future of Flux, see the following:

State of the InfluxDB Cloud Serverless documentation

InfluxDB Cloud Serverless documentation is a work in progress.

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.