# Does ray dataset support a display method similar to dataframe

**URL:** <https://discuss.ray.io/t/does-ray-dataset-support-a-display-method-similar-to-dataframe/8716>\
**Category:** Ray Data\
**Created:** [December 20, 2022, 12:19pm UTC](https://discuss.ray.io/t/does-ray-dataset-support-a-display-method-similar-to-dataframe/8716 "2022-12-20T12:19:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![839576266](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.ray.io/839576266/32/2235_2.png) [@839576266](https://discuss.ray.io/u/839576266)\
**Post date:** [December 20, 2022, 12:19pm UTC](https://discuss.ray.io/t/does-ray-dataset-support-a-display-method-similar-to-dataframe/8716/1 "2022-12-20T12:19:03Z")

</div>

hello:  
I am using ray for data index statistics, but I found that ray cannot modify the name of the index column like pandas. How should I deal with this situation?

 ![WechatIMG2134](https://us1.discourse-cdn.com/flex020/uploads/ray/original/2X/7/7eaa6257228c513f767a9c3c028e53caaa90235c.jpeg)  
 ![WechatIMG2135](https://us1.discourse-cdn.com/flex020/uploads/ray/original/2X/6/6f33b3037fc1b1bcbfb3e12ad4913587971773da.jpeg)

---

<div class="post-metadata">

**Author:** ![cade](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.ray.io/cade/32/3837_2.png) [@cade](https://discuss.ray.io/u/cade)\
**Post date:** [December 22, 2022, 9:30pm UTC](https://discuss.ray.io/t/does-ray-dataset-support-a-display-method-similar-to-dataframe/8716/2 "2022-12-22T21:30:09Z")

</div>

Moving to Ray AIR category.

---

<div class="post-metadata">

**Author:** ![chengsu](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.ray.io/chengsu/32/2922_2.png) [@chengsu](https://discuss.ray.io/u/chengsu)\
**Post date:** [December 23, 2022, 11:45pm UTC](https://discuss.ray.io/t/does-ray-dataset-support-a-display-method-similar-to-dataframe/8716/3 "2022-12-23T23:45:53Z")

</div>

Hi @839576266 - could you help provide an example code for Pandas? What you want to achieve in Ray Data?

---

<div class="post-metadata">

**Author:** ![839576266](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.ray.io/839576266/32/2235_2.png) [@839576266](https://discuss.ray.io/u/839576266)\
**Post date:** [December 26, 2022, 6:20am UTC](https://discuss.ray.io/t/does-ray-dataset-support-a-display-method-similar-to-dataframe/8716/4 "2022-12-26T06:20:15Z")

</div>

Thank you for your reply.  
I want to use ray to realize the function of data indicator statistics, but when the data is saved, I find that ray Dataset cannot output a column with indicator names (such as sum and mean) like pandas

```auto
import pandas as pd
dict = {'x_0': [1, 2, 3], 'x_1': [4, 5, 6]}
df = pd.DataFrame(dict)
print(df.describe())

```

---

<div class="post-metadata">

**Author:** ![sjl](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.ray.io/sjl/32/6672_2.png) [@sjl](https://discuss.ray.io/u/sjl)\
**Post date:** [January 12, 2023, 6:53pm UTC](https://discuss.ray.io/t/does-ray-dataset-support-a-display-method-similar-to-dataframe/8716/5 "2023-01-12T18:53:49Z")

</div>

Hi @839576266 , currently when creating a Ray Dataset from an existing Pandas DataFrame ([ray.data.from\_pandas](https://docs.ray.io/en/latest/data/api/input_output.html#ray.data.from_pandas)), the resulting Dataset does not carry over the index column.

For the code you are writing, is it a requirement that the indicator names from the Pandas DataFrame must stay in the index? Or is it possible to move it out into a column with [pd.DataFrame.reset\_index()](https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.reset_index.html)? If this is OK, then you could accomplish your desired result with something like:

```auto
>>> import pandas as pd
>>> dct = {'x_0': [1, 2, 3], 'x_1': [4, 5, 6]}
>>> df = pd.DataFrame(dct)
>>> df_summary = df.describe().reset_index()
>>> df_summary
   index x_0 x_1
0 count 3.0 3.0
1 mean 2.0 5.0
2 std 1.0 1.0
3 min 1.0 4.0
4 25% 1.5 4.5
5 50% 2.0 5.0
6 75% 2.5 5.5
7 max 3.0 6.0
>>> import ray
>>> ds_summary = ray.data.from_pandas(df_summary)
>>> ds_summary.schema()
PandasBlockSchema(names=['index', 'x_0', 'x_1'], types=[dtype('O'), dtype('float64'), dtype('float64')])
>>> ds_summary.take_all()
[{'index': 'count', 'x_0': 3.0, 'x_1': 3.0}, {'index': 'mean', 'x_0': 2.0, 'x_1': 5.0}, {'index': 'std', 'x_0': 1.0, 'x_1': 1.0}, {'index': 'min', 'x_0': 1.0, 'x_1': 4.0}, {'index': '25%', 'x_0': 1.5, 'x_1': 4.5}, {'index': '50%', 'x_0': 2.0, 'x_1': 5.0}, {'index': '75%', 'x_0': 2.5, 'x_1': 5.5}, {'index': 'max', 'x_0': 3.0, 'x_1': 6.0}]

```

---

<div class="post-metadata">

**Author:** ![839576266](https://sea2.discourse-cdn.com/flex020/user_avatar/discuss.ray.io/839576266/32/2235_2.png) [@839576266](https://discuss.ray.io/u/839576266)\
**Post date:** [January 16, 2023, 5:47am UTC](https://discuss.ray.io/t/does-ray-dataset-support-a-display-method-similar-to-dataframe/8716/6 "2023-01-16T05:47:58Z")

</div>

Thanks for your reply,I try to solve my question with your method.
