topic Re: Pivot a DataFrame in Delta Live Table DLT in Data Engineering

Pivot a DataFrame in Delta Live Table DLT

Khalil — Wed, 19 Apr 2023 17:38:54 GMT

I wanna apply a pivot on a dataframe in DLT but I'm having the following warning

Notebook:XXXX used `GroupedData.pivot` function that will be deprecated soon. Please fix the notebook.

I have the same warning if I use the the function collect.

Is it risky not to correct it.

Re: Pivot a DataFrame in Delta Live Table DLT

Khalil — Thu, 20 Apr 2023 06:48:03 GMT

Thank you @Kaniz Fatma for that great answer. This can be a good workaround but the other issue I am facing is that collect function will be deprecated soon as well in Delta Live Table.

Re: Pivot a DataFrame in Delta Live Table DLT

Khalil — Fri, 21 Apr 2023 05:41:48 GMT

Hi @Kaniz Fatma , I get your point; it might be risky to use toPandas as you said but as I need just to retrieve distinct values from a specific column of the dataframe so toPandas might be used in this case.

I will try this approch and let you know.

Re: Pivot a DataFrame in Delta Live Table DLT

Anonymous — Sun, 23 Apr 2023 15:24:27 GMT

Hi @Ibrahima Fall

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance!

Re: Pivot a DataFrame in Delta Live Table DLT

Khalil — Wed, 26 Apr 2023 17:09:52 GMT

Thanks @Kaniz Fatma for your support.

The solution was to do the pivot outside of views or tables and the warning disappeared.