# Data Mapping cfxdm - dm:describe

**dm:describe:** This cfxdm tag allows the user to select one or more columns and provides below summarized statistics on the values within them.

* **count:** Total count of the values within a column
* **unique:** Total unique count of the values within a column
* **top:** The top value out of all unique values which are repeated compared to others
* **freq:** The number of times the top unique is repeated
* **mean:** The mean out of all of the values (applies to rows that only has numeric values)
* **std:** The standard deviation out of all of the values (applies to rows that only has numeric values)
* **min:** The minimum value out of all of the values (applies to rows that only has numeric values)
* **25%:** 25% percentile out of all of the values (applies to rows that only has numeric values)
* **50%:** 50% percentile out of all of the values (applies to rows that only has numeric values)
* **75%:** 75% percentile out of all of the values (applies to rows that only has numeric values)
* **max:** The maximum value out of all of the values (applies to rows that only has numeric values)

**dm: describe** synta&#x78;**:**&#x20;

* **columns (**&#x6F;ptiona&#x6C;**)**. Specify a column or columns (comma separated) on which '**describe**' to be applied.

This section explains how users can use a CSV file loaded into a dataset. This saved dataset will be used to explain how the dm: describe function to display the stats of the dataset.

{% hint style="info" %}
Download the [incidents.csv](https://macaw-amer.s3.amazonaws.com/rda/data/incidents.csv) file to the local machine as shown below using a standard web browser
{% endhint %}

### Example 1:

Step 1:  Download 'incidents.csv' to the AIOps RDA environment as shown below from the local file system.

![Downloaded file on local filesystem](/files/-MbcPmsKgRqacQ_K6i0b)

Step &#x32;**:** Upload the file 'incidents.csv' to AIOps studio using file-browser (as shown below)

![Screenshot displays how to upload a file into AIOps Studio.](/files/-MbcQiEiFxhuzCwcyT76)

![](/files/-MbcRNIUtmLyJ08hPjZu)

Step &#x33;**:** Add a new empty pipeline with the name "**dm\_describe\_example\_1**" as shown below and click the "Save" button (this step will create an empty pipeline and saves it to AIOps studio).

![Empty pipeline](/files/-Mf-HhJj4ZJawMKzw09g)

Step 4: Add the following pipeline commands into the empty pipeline text field that you have created in above Step 3.

You can copy the below code into your pipeline and execute that in your environment.\
\&#xNAN;*`##### This pipeline loads incidents.csv file into AIOps Studio.`*                          \
*`##### AIOps studio stores the data loaded from incidents.csv file`*\
*`##### into local dataset named 'incident-summary'.`*\
*`##### prints the data that was stored`*\
*`@files:loadfile filename = "incidents.csv"`*\
*`--> @dm:save name = 'incidents-summary'`*\
*`--> *dm:filter *`* <br>

Step 5:  Check the data from incidents.csv by executing the pipeline and verifying using inspect data as shown below (screenshot -1 & screenshot-2)

![screenshot-1](/files/-Mf-JgiH6mhwGFTAGTY2)

![screenshot-2](/files/-Mf-K9155B4sSdNEO1yp)

Step 6: Now, add the following additional pipeline code to use the dm: describe function to the previously created pipeline from Step-4 as shown below (Edit and add the following pipeline code) and click verify to verify the pipeline code as shown below.

*`##### This pipeline loads incidents.csv file into AIOps Studio.`*                          \
*`##### AIOps studio stores the data loaded from incidents.csv file`*\
*`##### into local dataset named 'incident-summary'.`*\
*`##### prints the data that was stored`*\
*`@files:loadfile filename = "incidents.csv"`*\
*`--> @dm:save name = 'incidents-summary'`*\
*`--> *dm:filter *`* \
*`--> @dm:describe`*<br>

![Pipeline code is verified using 'Verify' button as shown above.](/files/-Mf-M7OjCHMhyz7OV5uw)

Step &#x37;**:** Click execute button and execute the pipeline. RDA will execute the pipeline without any errors (as shown below)

![Successful execution of pipeline using dm function 'dm:describe' and prints output. ](/files/-Mf-MqJ-o5Xk-7kl8Kyj)

Step 8: RDA uses the dm describe function to describe the statistics of the selected 'incidents.csv' dataset that was loaded earlier (and saved) as shown in the following screenshot.

![Summarized statistics ouput from incidents.csv dataset.](/files/-Mf-QflxuBFlanXX_apH)

### Example 2:

Now, add the following additional pipeline code to use the dm: describe function to the previously created pipeline from Step-4 as shown below (Edit and add the following pipeline code) and click verify to verify the pipeline code as shown below.

*`##### This pipeline loads incidents.csv file into AIOps Studio.`*                          \
*`##### AIOps studio stores the data loaded from incidents.csv file`*\
*`##### into local dataset named 'incident-summary'.`*\
*`##### prints the data that was stored`*\
*`@files:loadfile filename = "incidents.csv"`*\
*`--> @dm:save name = 'incidents-summary'`*\
*`--> *dm:filter *`* \
*`--> @dm:describe columns = 'Summary,Source'`*

Once the above pipeline code is added and executed, stats are provided to selected two columns as shown below screenshot.

![](/files/-Mf-StnwWHqKmAA2I3ly)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cloudfabrix.io/rda/rda-userguide/rda-aiops-studio/examples-jupyter/data-mapping-cfxdm-dm-describe.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
