# Python Client write\_api.write()

**URL:** <https://community.influxdata.com/t/python-client-write-api-write/29320>\
**Category:** Client SDKs\
**Tags:** influxdb, python\
**Created:** [March 31, 2023, 10:39am UTC](https://community.influxdata.com/t/python-client-write-api-write/29320 "2023-03-31T10:39:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MarkSCQ](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/markscq/32/12513_2.png) [@MarkSCQ](https://community.influxdata.com/u/MarkSCQ)\
**Post date:** [March 31, 2023, 10:39am UTC](https://community.influxdata.com/t/python-client-write-api-write/29320/1 "2023-03-31T10:39:27Z")

</div>

When using write\_api.write() I found that the data would be processed as shown below.

Image 1 the origin data

 ![b77131cd4af3ceb48d870deeea5a26f](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/1/10a542a8ba1ee7ea7bbe19294de5ed90a66ead4a.png)

Image 2 the exported data from frontend

 ![image](https://us1.discourse-cdn.com/flex023/uploads/influxdata/original/2X/6/6dc6de9ce1ca91d7b1aec63cbe72290af76c807f.png)

It seems Influx has done some data transformation for me. But, how can I avoid it, I mean if I want to use the original data, what should I do?

Thank you!!!

---

<div class="post-metadata">

**Author:** ![Anaisdg](https://sea1.discourse-cdn.com/flex023/user_avatar/community.influxdata.com/anaisdg/32/6401_2.png) [@Anaisdg](https://community.influxdata.com/u/Anaisdg)\
**Post date:** [April 4, 2023, 8:22pm UTC](https://community.influxdata.com/t/python-client-write-api-write/29320/2 "2023-04-04T20:22:37Z")

</div>

Hello @MarkSCQ,  
You can use the pivot or fieldsAsCol function:

> **[pivot() function | Flux 0.x Documentation](https://docs.influxdata.com/flux/v0.x/stdlib/universe/pivot/)**
>
> pivot() collects unique values stored vertically (column-wise) and aligns them horizontally (row-wise) into logical sets.

> **[schema.fieldsAsCols() function | Flux 0.x Documentation](https://docs.influxdata.com/flux/v0.x/stdlib/influxdata/influxdb/schema/fieldsascols/#Copyright)**
>
> schema.fieldsAsCols() is a special application of pivot() that pivots input data on \_field and \_time columns to align fields within each input table that have the same timestamp.

(fields as col is a wrapped version of pivot for your specific use case)

Also please note that if you plan on using influxdb cloud powered by iox it will return data as you expect.  
Idk if that applies to you. Just putting it out there.