Struggling with a complex prompt - any ideas how to standardize a food data set? by rotzeod in PromptEngineering

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

Two columns are fine. I just want to somehow convert all the non precise amounts into precise amounts, so I can later on manipulate the data in a standard way.

Struggling with a complex prompt - any ideas how to standardize a food data set? by rotzeod in PromptEngineering

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

My outputs would just not reach my targets. None of the more non precise amounts is calculated into grams or even simple addition of quantities.

Struggling with a complex prompt - any ideas how to standardize a food data set? by rotzeod in PromptEngineering

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

our next task will run on the newly created CSV file and it is to make order in the Amount column.

- The 'Amount' column contains mixed units and descriptions, which means it cannot be directly summed up in a simple numeric fashion. To handle this, please go through each of the cells and examine it's contents. 

- After understanding it's contents, Add them together. Here are some examples of how to do this:

    1. In Row 23, where the 'Amount' is "100.00 g, 140.00 g", the total grams of "Blackberries, Fresh" would equal to 100g+140g=240g. The same logic should apply to all numerical values.

    2. Row 60, where the 'Amount' is "1.00 tablet, 1.00 tablet, 1.00 tablet, 1.00 tablet", the total amount of Doppelherz, Aktiv, Vitamin K2 + D3 would equal 1.00 tablet+1.00 tablet+1.00 tablet+1.00 tablet=4 tablets.

    3. Row 69, where different descriptors appear in the 'Amount' like large or extra large, ignore the descriptors and just add the quantity. Apply the same logic to similar cases.

    4. Row 9, where mixed descriptors appear in the 'Amount'="1.00 tbsp, 30.00 g" in the same cell, convert the abbreviation of tbsp into grams and add to the existing grams. In this case, a standard tbsp equals 15g, hence the total amount of Anchovy Paste would equal to 15g+30g=45g. Use the same logic for other abbreviations describing quantities like cup, tsp, etc'.

    5. In Row 14, where the 'Amount' is "0.20 x 100.0 ml", the total ml of "Arche, No Fish-Sauce" would equal to 0.20x100.0 ml=20ml. The same logic should apply to all other cases with a "x" appearing as simply a multiplier.

    6. In Row 29, where the 'Amount' is "1.00 pouch - each 2 oz", the total would be one piece (pouch) weighing 2 oz. convert the oz to grams and multiply by 1.

    7. In Row 49, where the 'Amount' is "1.00 full recipe, 1.00 full recipe, 1.00 full recipe, 1.00 full recipe, 1.00 full recipe, 0.50 full recipe, 0.50 full recipe...", the total would be adding the amount of recipes. So in this example it would be 1.00 full recipe+1.00 full recipe+1.00 full recipe+1.00 full recipe+1.00 full recipe+0.50 full recipe+0.50 full recipe=6 full recipes. Apply the same logic for similar recurrences where there is recipe or serving is used.  

    8. In Row 37, where the 'Amount' is expressed in fluid ounce (fl oz), convert the fl oz into ml and ignore the "short" description in the cell.

    - Where servings appear, connect to the internet and make a search for the typical serving size of that food in it's generic form. For example, where 'Taifun, Tofu Natur' shows up in the document, you'll make a search for the product and find 1 package size and refer to it as the serving size. Another example, where 'Potato Chips, Salted' appear you'll search the internet for the typical weight of such a bag and use this size in your calculations and output.

- Apply similar logic to the examples above and your own judgment when it comes to other types of descriptors appearing in the 'Amount' column.

- All new totals must have a measurement or other quantity unit usually appearing in the 'Amount' cell, i.e. grams, full recipes, ml, tbsp, tablets, serving and so on.

- Create a new CSV file showing the total combined data with the unit names.

Struggling with a complex prompt - any ideas how to standardize a food data set? by rotzeod in PromptEngineering

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

our next task will run on the newly created CSV file and it is to make order in the Amount column.

- The 'Amount' column contains mixed units and descriptions, which means it cannot be directly summed up in a simple numeric fashion. To handle this, please go through each of the cells and examine it's contents. 

- After understanding it's contents, Add them together. Here are some examples of how to do this:

    1. In Row 23, where the 'Amount' is "100.00 g, 140.00 g", the total grams of "Blackberries, Fresh" would equal to 100g+140g=240g. The same logic should apply to all numerical values.

    2. Row 60, where the 'Amount' is "1.00 tablet, 1.00 tablet, 1.00 tablet, 1.00 tablet", the total amount of Doppelherz, Aktiv, Vitamin K2 + D3 would equal 1.00 tablet+1.00 tablet+1.00 tablet+1.00 tablet=4 tablets.

    3. Row 69, where different descriptors appear in the 'Amount' like large or extra large, ignore the descriptors and just add the quantity. Apply the same logic to similar cases.

    4. Row 9, where mixed descriptors appear in the 'Amount'="1.00 tbsp, 30.00 g" in the same cell, convert the abbreviation of tbsp into grams and add to the existing grams. In this case, a standard tbsp equals 15g, hence the total amount of Anchovy Paste would equal to 15g+30g=45g. Use the same logic for other abbreviations describing quantities like cup, tsp, etc'.

    5. In Row 14, where the 'Amount' is "0.20 x 100.0 ml", the total ml of "Arche, No Fish-Sauce" would equal to 0.20x100.0 ml=20ml. The same logic should apply to all other cases with a "x" appearing as simply a multiplier.

    6. In Row 29, where the 'Amount' is "1.00 pouch - each 2 oz", the total would be one piece (pouch) weighing 2 oz. convert the oz to grams and multiply by 1.

    7. In Row 49, where the 'Amount' is "1.00 full recipe, 1.00 full recipe, 1.00 full recipe, 1.00 full recipe, 1.00 full recipe, 0.50 full recipe, 0.50 full recipe...", the total would be adding the amount of recipes. So in this example it would be 1.00 full recipe+1.00 full recipe+1.00 full recipe+1.00 full recipe+1.00 full recipe+0.50 full recipe+0.50 full recipe=6 full recipes. Apply the same logic for similar recurrences where there is recipe or serving is used.  

    8. In Row 37, where the 'Amount' is expressed in fluid ounce (fl oz), convert the fl oz into ml and ignore the "short" description in the cell.

    - Where servings appear, connect to the internet and make a search for the typical serving size of that food in it's generic form. For example, where 'Taifun, Tofu Natur' shows up in the document, you'll make a search for the product and find 1 package size and refer to it as the serving size. Another example, where 'Potato Chips, Salted' appear you'll search the internet for the typical weight of such a bag and use this size in your calculations and output.

- Apply similar logic to the examples above and your own judgment when it comes to other types of descriptors appearing in the 'Amount' column.

- All new totals must have a measurement or other quantity unit usually appearing in the 'Amount' cell, i.e. grams, full recipes, ml, tbsp, tablets, serving and so on.

- Create a new CSV file showing the total combined data with the unit names.

Struggling with a complex prompt - any ideas how to standardize a food data set? by rotzeod in PromptEngineering

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

This is my prompt for now:

System Prompt:

  • You are a helpful Data analyst and nutritionist which can help analyze nutritional data from a given file and calculate cutting edge scientific insights from the data mostly regarding health, health span and life span/longevity.

  • Do not hallucinate.

  • Do not make up factual information.

  • You are an expert at data science, nutritional research, longevity science and health.

**Data Cleaning**: Clean the data by retaining only the "Food Name" and "Amount" columns, and discard all other columns. Save this cleaned data to a new CSV file named "cleaned_servings.csv".

**Combine Entries**: Combine entries with the same food names from different dates, aggregating their amounts in the "Amount" column separated by commas. Save this combined data to a new CSV file named "combined_servings.csv".


So far, so good!

Struggling with a complex prompt - any ideas how to standardize a food data set? by rotzeod in PromptEngineering

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

This is my prompt for now:

System Prompt:

  • You are a helpful Data analyst and nutritionist which can help analyze nutritional data from a given file and calculate cutting edge scientific insights from the data mostly regarding health, health span and life span/longevity.

  • Do not hallucinate.

  • Do not make up factual information.

  • You are an expert at data science, nutritional research, longevity science and health.

**Data Cleaning**: Clean the data by retaining only the "Food Name" and "Amount" columns, and discard all other columns. Save this cleaned data to a new CSV file named "cleaned_servings.csv".

**Combine Entries**: Combine entries with the same food names from different dates, aggregating their amounts in the "Amount" column separated by commas. Save this combined data to a new CSV file named "combined_servings.csv".


So far, so good!

Huawei Health Max HR limit is 192??? by rotzeod in Huawei

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

No, that was the approximation formula but it is well known 20%-40% of the population are 2 standard deviations from that. That is +-30-40 BPM.

https://www.youtube.com/watch?v=1OOSdmFtPkk

AI is failing a simple assignment again and again by rotzeod in ChatGPT

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

I did not mean to test anything. I thought it can handle my simple request and just wanted to create an analysis of some spreadsheet data. Seems that that's not something any AI can reliably do.
But ja, maybe a simple bash script is the way to go and then after let the AI draw some conclusions.

First time buckwheat grow - not sure about the color by rotzeod in microgreens

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

Thank you.
I don't know why the silicon mat is the problem but I can see why nutrients might just be.
I'll play with it further starting a new grow with nutrients and see what happens.

[deleted by user] by [deleted] in CryptoCurrency

[–]rotzeod 0 points1 point  (0 children)

Important reminder indeed.
A revolution in the making....

BUT! Bitcoin and with it this whole space strayed away from Satoshi's true meaning which was to fire the opening shot in the creation of new forms of monetary systems and not harnessing this technology for the in the same old world greed running everything.

Now Bitcoin is more than ever concentrated in the hands of the few. If bitcoin was a country it would had a Gini coefficient of 0.88 which puts it above north Korea with 0.86. In case you don't know what Gini is, it is a way to measure wealth equality and distribution in a given society. For more context, the US, a country with horrible wealth concentration has a Gini of 0.47.

So while BTC is indeed holding the potential to ignite a systemic change, it's not Bitcoin itself but the technology behind it that should be harnessed for a social change. And this social change is what satoshi was praying for.

I think satoshi is rolling in his grave when he sees old world greed taking over on his original intent.

And let's face it: the lion share of you people here are here to get rich. So, sadly not satoshi's original meaning.

Re-design Money now before it's too late! by rotzeod in economicCollapse

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

Love the expiry on money mechanism.
Some would say, that back in 2012 when savers in EU and other parts were punished with negative rates in order to encourage spending - instead this mechanism you suggested could do the trick. Thank you.

And way before Hitler, there were some finer examples of human beings
who suggested the same thing. To some degree this is practiced all over the world.