How Pandas/Perspective represent table pivots in arrow

2021-07-21 Thread Michael Lavina
Hello Apache Arrow Team, I am looking at ways my company can create an SDK that can share apache arrow data while preserving table pivots. I was looking at how Pandas and Perspective do it and it seems like For row_pivots Pandas just sorts the data into a flat arrow structure Perspective actu

Re: Apache Arrow Cookbook

2021-06-21 Thread Michael Lavina
Awesome idea! I would definitely either copy paste or link to Paul’s codepens of Arrow-JS examples https://codepen.io/trxcllnt/pens/public That’s basically how I know, how to use arrow-js. -Michael P.S. Just a general thank you credit for Paul Taylor and his awesome work on arrow-js and those

Re: apache arrow js documentation?

2021-04-23 Thread Michael Lavina
The documentation, from my understanding, is basically spread around 1. Within the actual files https://github.com/apache/arrow/blob/master/js/src/table.ts#L118 2. Within the examples/unit test https://github.com/apache/arrow/blob/master/js/test/unit/ipc/reader/stream-reader-tests.ts 3.

[Python] Custom Metadata in PyArrow

2021-04-23 Thread Michael Lavina
Hello Team, The docs for Custom Metadata in PyArrow say TODO https://arrow.apache.org/docs/python/data.html#custom-schema-and-field-metadata So I am wondering if someone has any example of adding some custom metadata to PyArrow. I tried looking through the pyarrow github repo and looking at the

Standard/Reserved Metadata keys

2021-04-08 Thread Michael Lavina
Hey Team, I noticed that under extension type the Arrow docs specifically call out to `ARROW:extension:name` and `ARROW:extension:metadata` as recommended/reserved metadata keys to handle extension types. 2 quick questions 1. Do the standard libraries handle that metadata key automaticall

Re: [DISCUSS] How to encode table_pivot information state in Arrow

2021-03-19 Thread Michael Lavina
@arrow.apache.org Subject: Re: [DISCUSS] How to encode table_pivot information state in Arrow Perspective uses arrow across the wire but internally uses it's own formats. Tim Paine tim.paine.nyc 908-721-1185 > On Mar 19, 2021, at 09:46, Michael Lavina wrote: > > Hey Benjamin, &

Re: [DISCUSS] How to encode table_pivot information state in Arrow

2021-03-19 Thread Michael Lavina
into core Arrow (which would probably include an analog of pandas' pivot_table), but the query engine work is a prerequisite. Ben Kietzman On Fri, Mar 19, 2021, 08:19 Michael Lavina wrote: > Hey Team, > > Sorry if this is answered already somewhere I tried searching emails and > is

[DISCUSS] How to encode table_pivot information state in Arrow

2021-03-19 Thread Michael Lavina
Hey Team, Sorry if this is answered already somewhere I tried searching emails and issues but couldn’t find anything. I am wondering if there is a standard way to encode row or column pivots in Arrow? I know Pandas does it already some way https://pandas.pydata.org/pandas-docs/stable/reference

Re: [JS] Exploring usage of apache arrow at my company for complex table rendering

2021-03-03 Thread Michael Lavina
n my work again soon, and that could justify more > "quality of life" improvements again, but without other maintainers jumping > in to contribute or needing it for my work, those things don't get done. > > I'd be happy to do a call with you or your team to give a

Re: [JS] Exploring usage of apache arrow at my company for complex table rendering

2021-02-26 Thread Michael Lavina
of the Arrow data. Neal On Fri, Feb 26, 2021 at 5:02 AM Michael Lavina wrote: > Hello Everyone, > > > > Some background. My name is Michael and I work at FactSet, which if you > use Arrow you may have heard because one of our architects did a talk on > using Ar

[JS] Exploring usage of apache arrow at my company for complex table rendering

2021-02-26 Thread Michael Lavina
Hello Everyone, Some background. My name is Michael and I work at FactSet, which if you use Arrow you may have heard because one of our architects did a talk on using Arrow and Dremio. https://hello.dremio.com/eliminate-data-transfer-bottlenecks-with-apache-arrow-flight.html?utm_medium=social-fr