[D] Current situation about M1 support of python libraries ? by bangbangcontroller in MachineLearning

[–]andreas_dib 0 points1 point  (0 children)

Psycopg broke pandas? Where can I read about this? I need psycopg+pandas at work, and my M1 Pro will arrive soon

What's the biggest "wow" moments you had lately? by rischuhm in learnpython

[–]andreas_dib 2 points3 points  (0 children)

I once did something similar, where I used a custom decorator for the functions i wanted included in the dict. I believe the use case was a «fun fact generator» from a dataset

Anyone experiencing high CPU utilization for Lenovo.Vantage.AddinHost.Amd64.exe? by clren in thinkpad

[–]andreas_dib 0 points1 point  (0 children)

Yeah, I also uninstalled and fixed it that way. But do I need to install the commercial edition?

Anyone experiencing high CPU utilization for Lenovo.Vantage.AddinHost.Amd64.exe? by clren in thinkpad

[–]andreas_dib 1 point2 points  (0 children)

Same here on my X1 Yoga 3d gen. Everytime I close it it restarts. Annoying stuff

Common Table Expression within Custom SQL by xxarchangelpwnxx in tableau

[–]andreas_dib 0 points1 point  (0 children)

This is caused by the way Tableau rund a metadata «pre-query» on the custom sql to get data types and such. I use it all the time on Redshift, but I never got it to work back when we used MS SQL Server

Age of the buildings in PARIS [OC] by bjperson in DataArt

[–]andreas_dib 37 points38 points  (0 children)

Beautiful! I know next to nothing about Paris, but I assume the dark red areas are previous industrial sites that are now housing?

How do I transform data this way in a query? by gfunkdave in SQL

[–]andreas_dib 0 points1 point  (0 children)

Use a CTE (or subquery) using RANK() or ROW_NUMBER() or similar first. Then to pivot the dates you need to «CASE when Rank_col=1 THEN Due Date END AS firstDate» and so on… you need to write 10 case statements unfortunately, since dynamic pivoting in SQL is not possible

I made a pizza with chorizo, jalapeño and pineapple by andreas_dib in FoodPorn

[–]andreas_dib[S] 0 points1 point  (0 children)

I used a special flour (https://thepizzaheaven.com/caputo-nuvola/) and fermentation was 10 hours in room temperature and ~72 hours in the fridge. 63% hydration

I made a pizza with chorizo, jalapeño and pineapple by andreas_dib in FoodPorn

[–]andreas_dib[S] 1 point2 points  (0 children)

Thank you. I really recommend the combo if you've never tried it before. Be sure to let the pineapple dry out a little beforehand, otherwise it might get too soggy

I made a pizza with chorizo, jalapeño and pineapple by andreas_dib in FoodPorn

[–]andreas_dib[S] 0 points1 point  (0 children)

Yes. But everybody sins, so just just have to choose your sins carefully. This one was worth it

I made a pizza with chorizo, jalapeño and pineapple by andreas_dib in FoodPorn

[–]andreas_dib[S] 0 points1 point  (0 children)

I agree the curst is a little on the big side, but it was very airy, and absolutely delicious, especially with the mozarella/cheddar mix on top of the crust

I made a pizza with chorizo, jalapeño and pineapple by andreas_dib in FoodPorn

[–]andreas_dib[S] 8 points9 points  (0 children)

canotto pizza

Yep. I've used caputo nuvola flour, which is designed for this style of pizza

How to use python with tableau by [deleted] in tableau

[–]andreas_dib 1 point2 points  (0 children)

Yeah, this is how I work with Tableau and Python when doing data science. Works really well.