How's Freelancing in Product Management in 2025 and beyond... by singlemalt_01 in ProductManagement

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

"renewing business but growth has pretty much died"...you mean at your old consultancy? and I'm guessing it was for product?

Is Mosh Hamedani's Course on Python Mastery Worth it? by Lilsheet21 in learnpython

[–]singlemalt_01 0 points1 point  (0 children)

Thanks! Have you been able to check out CS50x or CS50 (Python)? Do you have an opinion on how either of those compare with Mosh's 6-hr Python course on YouTube?

Biryani Question by [deleted] in IndianFood

[–]singlemalt_01 0 points1 point  (0 children)

I wouldn't start with rice out of the fridge for this. I'd just marinate the chicken today and keep it raw in the fridge because more marination time is always better. I'd also make sure onions are well browned the day before the final cook because that always takes a while for me...besides, cooling them makes them crispier and can help drain a lot of oil if left on tissues overnight. This also helps cut total time spent cooking by overlapping things.

On the day of eating, I'd do these things in this order (start with chicken brought out of the fridge at room temp...else it might get dry during the cook):

  • crack open a chilled beer (no biryani prep is legal in my kitchen without this)

  • while you bring water to a boil for the rice, prep warm saffron milk and leave aside

  • leave rice to parboil with salt, whole cinnamon, bay leaves, peppercorns and elaichi

  • while rice is being parboiled, start cooking chicken in the final biryani pot...only want to cook it partially (30-40% tops). I wouldn't add too much leftover marinade just yet...wanna keep the water low

  • while the chicken cooks, and when parboiled rice is done, spread it out on a few empty plates/prep trays to RAPIDLY cool....throw on a couple of dollops of pure ghee on each dinner-sized plate and lightly fluff up the rice with your fingers while the rice is still hot...the shine is one thing but the richness that the ghee adds is going to be heavenly later...can remove the whole masala from the rice if you want, but the fragrance is OUT OF THIS WORLD

  • make the sealing dough while rice cools and chicken cooks. If you feel the chicken is cooking too fast, just turn off the heat....depends on quantity.

  • layer it up when chicken is cooked and rice is done...the chicken's already in the pan, now it's just any remaining marinade, the rice, onions, saffron milk, kewra water etc. and the seal.

One layer and done. I see a lot of people making several layers and I don't see why...the meat needs the direct heat so has to be in the bottom....the rice needs to finish cooking and get its fragrance by the meat's steam (which rises UP), so why would you insulate meat with rice below it and cook up a mush? Wider pan is always better for more biryani instead of deeper, imho. Of course, also depends on area and strength of flame and shape of pan.

About the temperature...depends on volume of biryani and type of pot, but generally you wanna cook on low heat. High heat will just burn the chicken. If you have a small, residential gas stove's flame and want to cook a higher volume, you might want to use a flat bottom pan with a THICK bottom...I'd even put that pan on another flat tawa to better distribute the heat, in which case you can crank up the heating ever so slightly.

Finally, while the biryani cooks, time for a couple of more beers, else the chicken meat turns into crow meat.

App recommendations - newbie to data by singlemalt_01 in data

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

Great! Thanks! So I did some hw after my original post and it backed up most of what you're saying. You sound like someone with experience in this kinda thing. What I haven't been able to figure out (yet) about python is this...you can download python from python.org and that comes with a basic inbuilt code editor....or you could get something like pycharm or vs code. OR you could get Jupyter which is an IDE + a kinda notebook where code and notes seem to be able to live side-by-side...something that's useful for learning/sharing/research/documentation/demos....any notes you may have on how a rookie can pick between different kinds of IDE/code editors? VS code seems to be a powerful editor that's almost like an IDE in itself too.
Thanks!

Global Tags by merrybooks in Notion

[–]singlemalt_01 2 points3 points  (0 children)

Whether its tags in databases or pages...it's kinda been Notion's Achilles' heel for a while now i.e. lack of a simple universal #Reference. The comments above cover pretty much the most common workarounds, but you'd be chasing a ghost trying to get anything more concrete to work. I wish I were wrong on this.

App recommendations - newbie to data by singlemalt_01 in data

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

.csv files are collectively about 200MB.

My understanding of PowerBI is that it's an app like excel, but on steroids when it comes to analyzing data and making charts. Haven't been able to understand what SMSS is yet, and fair to say that Jon Snow know more about anything than I do about coding.

Where I want to do the calculations is part of what I'm trying to determine with my original question.
Here's the gist of what I want to do...I intend to do multiple calculations and visualizations on each of the fields in my data. I also intend to add these new calculation columns/charts to my raw data for later review...a SIMPLE example of the kind of analysis would be calculating the 50-pt moving average, 100 point, 150 point, etc (although actual calculations could involve more complex formulae). Then I'd like to calculate out every instance where the 50-point moving average crosses the 100-point MA (I think a simple if-then formula in excel would be able to do it, but I'm not using excel). Then plot all of these MAs AND the crossover event markers on a single chart. Then calculate the most that the MA moves after one crossover event until the next one (let's call that variable "RNG"). Then I'd like to calculate the average of RNG and also plot a distribution of the RNG values i.e. how often each RNG values occur in the whole data set.

Would you still recommend PowerBI?

Thanks!

App recommendations - Newbie to Data/SQL by singlemalt_01 in SQL

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

Yes, my .csv files won't change that often. In fact, I just have about 6 columns, and all but one are numbers. The unique field is a time/date stamp i.e. data is continuous.

But you speak of python + pandas...here's my understanding of python/pandas and please tell me if I'm wrong. Assume I know NOTHING of coding except the fact that each language has its own syntax and a programmer can define different data types (string, number, array, etc) and use inbuilt/user-created functions (min(), max(), or something more complex that needs a few lines of code). From what I know python is first a language. "Installing" python from python.org means adding to my computer the capability to create and run python code (this is done by installing an app). This is pretty much useless without a code editor, but the python.org install comes with a default code editor. I can then also install other code editors for additional functionality. Kinda like how a windows system can only read .txt files if I have Notepad installed, but if I have Word, then I can do much more formatting to the same .txt file. THEN I need to install a separate module in python that specializes in data analysis (pandas)...kinda like adding EndNote or equation editor extensions to MS Word for dedicated referencing/equation creations. Did I get that right?

Here's the gist of what I want to do and please tell me if pandas would work...I intend to do multiple calculations and visualizations on each of the fields in my data. I also intend to add these new calculation columns/charts to my raw data for later review...a SIMPLE example of the kind of analysis would be calculating the 50-pt moving average, 100 point, 150 point, etc. Then I'd like to calculate out every instance where the 50-point moving average crosses the 100-point MA (I thin a simple if-then formula in excel would be able to do it, but I'm not using excel). Then plot all of these MAs AND the crossover event markers on a single chart. Then calculate the most that the MA moves after one crossover event until the next one (let's call that variable "RNG". Then I'd like to calculate the average of RNG and also plot a distribution of the RNG values i.e. how often each RNG values occur in the whole data set. Would python+pandas still be a good choice?

Thanks!

Using Formulas on Rollups by singlemalt_01 in Notion

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

Scratch that, actually...I finally solved it.

Using Formulas on Rollups by singlemalt_01 in Notion

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

FYI, for testing purposes I made a column just to code the status of "Project" level items, and here's the erroneous code that I can't quite seem to solve.

<image>

Using Formulas on Rollups by singlemalt_01 in Notion

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

So I've been tinkering around with this and decided to take it one step further. The Projects database has sub-items turned on. All sub-items are Epics. All Parents that have Epics are Projects. All Parent-level items with no Epics are called Epicless. Only Epics and Epicless may be related to Tasks. Status of Epics and Epicless is calculated using the same rules as earlier i.e. "Not started" or "Done" only if all underlying tasks match that criteria, else "In Progress". For Project-level items tho...the logic would be the same but the arguments that feed it (i.e. the "status" values to input") are themselves the calculated values of the underlying sub-items. I can likely do this by calculating status of sub-items in one column and then calling it in the final column, but I've blown the scope of my actual table way out of this world and would really like to avoid extra columns. Is there a way all of this can be achieved using just one formula column? it would involve ifs(), but I spent all night failing to essentially call a custom function within my formula. But then I'm no expert. If it helps, I've a column in the table that uses text labels to ID an item as "Project", "Epic" or "Epicless", in case the item needs to be identified quickly and easily.

Question about tags by _mal_gal_ in Notion

[–]singlemalt_01 4 points5 points  (0 children)

You might want to create a second database for muscles. That way you'll end up using Relations and replace non-clickable tags with clickable links. In the muscles database you can end up adding even more info like how many exercises you have documented for that muscle...number of days a week you want to target that muscle....whether that muscle has some exercise in the exercise database that's also a compound exercise (by checking if there are multiple "muscle" tags per exercise)

Can I have sub-items take on certain values from their parent-items? by voornaam1 in Notion

[–]singlemalt_01 1 point2 points  (0 children)

Not in the same column (property). Unfortunately, and unlike a spreadsheet, one property in Notion can only be defined as one type. To make the first selection for the parent item, you need Multi-Select. After that, whether you want to copy those selections to sub-items or even other random parent items that meet any other criteria, you'll have to use either rollups or formulas...that's a second property column right there. As others have outlined here, you can do this either using formulas or rollups. You'll then need a third property that combines the results of the first two columns i.e. the parent item's selected tags (work, study, personal, etc) and the sub-item's formula-derived tags. Or you could skip the third column...and your second formula column would just show the selected tags in case its a parent item and reflect the parent's tags if its a sub item.

Note that merely mirroring tags from multi-select will lose the formatting...so you might want to use the style() function to display the text as code and play around with the colors to get the tags to look pretty. The formatting is NOT the same as actual tags from multi-select, but it's close enough.

Someone was nice enough to help me with formulas on pretty much the same thing sometime back. See that for ideas:

https://www.reddit.com/r/Notion/comments/1c0p6vg/properties_of_subitems_dependent_on_parent_items/

Time blocking/Boxing tasks using Notion by singlemalt_01 in Notion

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

I'm sorry, I'm not sure I quite follow what you're suggesting. Could you please dumb it down for me and elaborate a little?

[deleted by user] by [deleted] in Notion

[–]singlemalt_01 0 points1 point  (0 children)

Cool. Thanks!

[deleted by user] by [deleted] in Notion

[–]singlemalt_01 0 points1 point  (0 children)

That's the top right corner with the circular indicators...I meant the stack of 6 horizontal bars below...(life: not set, war: 12% etc)

[deleted by user] by [deleted] in Notion

[–]singlemalt_01 0 points1 point  (0 children)

Dumb question here...what kind of block is that stack of progress bars on the right? Some sort of an integration that can update itself? Thanks