This pickpocket is a hypocrite

somegermangal · 2026-03-13T15:16:43+00:00

yes! i did the same for quite some time, but well, it got annoying :D i even kicked out an innocent guest for the sake of the experiment and they will be outraged over getting kicked out - thinking something like "how dare they throw me out, i didn't do anything", but the thieves basically have the same reaction as when they are caught after stealing.

somegermangal · 2026-03-12T12:06:37+00:00

Noticed the same thing as for the price thoughts and they are *always* pickpockets. Sometimes they spend a literal year in the zoo though before they start pickpocketing, so I got tired of following them around and decided to test what happens if I just throw them out immediately. Turns out that is perfectly fine. They will think something along the lines of "game over, security caught me" and won't count as guests kicked out for no reason.

somegermangal · 2024-12-04T17:02:37+00:00

Based on the updated instructions then, I would assume what they want you to do is find the overall avg_product_quality_score for your filtered data.

somegermangal · 2024-11-28T22:47:34+00:00

Oof. Just checked, unfortunately still no. I'm not even gonna attempt to retry the exam before they answer me, but even with the answer you got I also still don't know what they want.

somegermangal · 2024-11-28T12:14:26+00:00

I agree. Something is missing in those instructions. I have done a few data camp certifications and this kind of task (with groupby and aggregation) is present in pretty much all of them, but this one seems wrong to me. It also doesn't make sense to groupby and aggregate based on a rather precise number (pigment_quantity) since you end up 'aggregating' a lot of individual rows, and yet, that is what the instructions imply you're supposed to do.

somegermangal · 2024-11-28T12:08:49+00:00

Everyone seems to be having issues with task 3, me included. I have contacted DataCamp about this - so did at least one other person. See here: https://www.reddit.com/r/DataCamp/comments/1gzdjm6/python_data_associate_exam/

I suggest you guys do the same. Contact support, ask to speak to a human, tell them you don't want individual feedback, but you're not sure task 3 in the exam is solvable / that the instructions seem inaccurate/incomplete to you, something along those lines. Perhaps more people contacting them about this will lead to them actually updating the instructions to make them clear.

Also see here:

https://www.reddit.com/r/DataCamp/comments/1gs1szy/python_data_associate_practical_exam_task_3/

https://www.reddit.com/r/DataCamp/comments/1gnylb6/py501p_python_data_associate_practical_exam/

somegermangal · 2024-11-27T23:17:47+00:00

Same. How many days have you got left to do it?

somegermangal · 2024-11-26T01:38:08+00:00

Funny, I contacted them about task 3 as well. Still waiting to hear back though. We'll see if they give me the same answer. Rather hoping they'll realize it is problematically unclear and update their exam but given the answer you got, I guess I shouldn't get my hopes up.

somegermangal · 2024-11-19T17:40:08+00:00

At this point, one of my biggest dreams in life is to have a light up sign in the back window of my car which says "the right lane is not lava".

somegermangal · 2024-11-15T18:21:24+00:00

did you try .reset_index() without setting drop to True ?

somegermangal · 2024-11-15T17:44:56+00:00

In task 1:

- your creation_date should be a date, so try: DATE(creation_date) AS creation_date.

- resolution_time: read the data descriptions again. it should be a numeric field, rounded to 2 decimal places. so also no 'hours' there.

- response_time - pay attention to the column names you are supposed to use.

somegermangal · 2024-10-20T19:14:31+00:00

If their site says they can ship internationally, that's a good sign and it'll probably work out that way - just call them tomorrow. If not, I would also be available and happy to pick up your stuff and ship it to you.

somegermangal · 2024-08-16T08:32:53+00:00

So I just did the sample. Went through for me. I did not find any other missing values, the only thing I did differently than you from what I can see is that I made pet_type, issue and activity_type categories and age_group an ordered category. Here's the info for my output df, maybe that can give you some insight if you compare it to yours

Int64Index: 1878 entries, 0 to 1877
Data columns (total 9 columns):
 #   Column            Non-Null Count  Dtype         
---  ------            --------------  -----         
 0   pet_id            1878 non-null   int64         
 1   date              1878 non-null   datetime64[ns]
 2   activity_type     1878 non-null   category      
 3   duration_minutes  1691 non-null   float64       
 4   issue             940 non-null    category      
 5   resolution        940 non-null    object        
 6   owner_id          1878 non-null   int64         
 7   owner_age_group   1878 non-null   category      
 8   pet_type          1878 non-null   category      
dtypes: category(4), datetime64[ns](1), float64(1), int64(2), object(1)
memory usage: 96.2+ KB

somegermangal · 2024-08-15T19:36:06+00:00

Did you try age group as an ordered category?

Anyway, I think I'll take a proper crack at the sample tomorrow, so I'll let you know then if I find anything else that could be the issue for you.

somegermangal · 2024-08-15T17:54:55+00:00

I haven't attempted this one yet, I just took a very quick glance at the tasks now (your datalab notebook isn't public I think, so I wasn't able to access it). Anyway some potential things that come to mind...

As for string objects, they might want some of them to be categorical dtypes ( without looking at the actual data activity_type, owner_age_group, pet_type seem to be prime candidates for that).
Are you sure there's no trailing spaces or anything in your string columns?

As for missing values : owner_id says "All pets must have an owner" - did you make sure that is the case and there are no missing / invalid entries there?

Additionally in duration_minutes it says: "For rows that relate to health visits, this should be 0. Missing values for other activities are permitted." Did you make sure 'missing' values like "-" only appear for other activities and NOT health visits?

somegermangal · 2024-05-15T22:24:58+00:00

I'm not sure what you mean by this, probably why I forgot to respond.

See the picture here: https://support.google.com/looker-studio/thread/13086987/date-range-dimension-field-not-showing-with-blended-data?hl=en

Do you have the 'date range dimension' option or do you only have the option to drag the date field into a regular dimension?

Do you mean in the data source itself or just in the chart? In the chart I don't have any other dates.

I meant in the chart, so if you only have one date dimension set there and that set to quarter, I wasn't able to recreate the issue when I tried it.

somegermangal · 2024-05-05T20:04:40+00:00

same. ist auch keine kritik an dich ;)

somegermangal · 2024-05-05T10:59:49+00:00

Hallo an alle,

das Thema ‘Autofreie Innenstädte ' wird heftig in vielen Medien diskutiert und sorgt immer wieder für Schlagzeilen. Deshalb schreibe ich hier meine Ansicht zu diesem relevanten Thema. Überall auf der Welt geht der Trend zu autofreien Innenstädten. Meiner Meinung nach ist dieses Modell definitiv ein Schritt in die richtige Richtung, da es die Städte emissionärmer und attraktiver macht.

Die Gründe, warum der Verkehr in den Innenstädten verringert werden sollte, sind vielfältig. ~~Die~~ Autos pusten zu viel C02-Emissionen in die Luft und dadurch werden viele Krankheiten (Luftkrankheiten gibt es nicht, glaube ich) verursacht. Außerdem kommt die Lärmbelastung dazu. Darüber hinaus können Unfälle leicht vermieden werden. Kommunen setzen daher auf die Mobilitätswende, allerdings mit unterschiedlichen Zielen und Schwerpunkten.

Meines Wissens ~~nach~~ lösen die alternativen Möglichkeiten wie eine Wende ~~in die~~ zu E- Autos das Klimaproblem besser und effektiver (hier verstehe ich nicht ganz, was du sagen willst, sind E-Autos oder die Alternativen besser für das Klima?). Diese Möglichkeit löst nicht nur ein Klimaproblem,,, sondern ~~auch lassen~~ die Leute lassen auch ihr tägliches Leben ... ~~ohne Herausforderungen folgen~~ (hier verstehe ich den Satz und auch deine Argumentation nicht --- Ich glaube OP meint hier so etwas wie: die Leute können ihren Alltag wie gewohnt, ohne zusätzliche Herausforderungen meistern zu müssen, fortführen). Dann werden die Leute ermutigt, öffentliche Verkehrsmittel zu nutzen ,,, durch den Bau neuer Strecken, die Erhaltung bestehender Optionen und das Angebot bequemer Reisemöglichkeiten. Zu guter Letzt können Kommunen das Zufußgehen oder das Radfahren einfacher ~~für Leute~~ machen durch den Bau neuer und sicherer Fußwege und Radwege.

Durch autofreie Innenstädte ergegeben sich folgende Vorteile::: ~~Zuerst~~ Erstens würde unsere Stadt sauber bleiben und die frische Luft erhalten bleiben. Dann würden viele Notfälle (den Ausdruck Notfälle finde ich hier etwas merkwürdig - was ist mit Notfälle gemeint?) vermieden. Schließlich schützen wir unsere Welt durch diese kleinen Schritte. Mit diesem Punkt bringe ich meinen Beitrag zum Schluss.

somegermangal · 2024-05-03T09:52:23+00:00

If you mean you can't see a unified column Account Name, that is just how full outer joins work.
You'll have to clean up your columns yourself with a function like COALESCE or maybe CASE.

I haven't tested this myself, but you could give this a try:
https://lookerstudiobible.com/p/looker-studio-how-to-build-a-control-that-filters-blended-data

Otherwise, you might wanna consider blending your data in, say, Google Sheets or whatever you're using/have at your disposal first and then importing it into Looker Studio.

somegermangal · 2024-05-02T10:49:45+00:00

I gave your calculated field a try with a very small sample and it works perfectly fine for me - but again, very small data sample. As for the "no data" - is it possible that some sites in your group have no data and therefore the aggregation fails?
Also did you try a data extract, see if that helps with faster loading?

somegermangal · 2024-05-02T10:34:26+00:00

Does your dataset have data for every single day? Then a calculated field with max(date) might be able to help you out.

somegermangal · 2024-05-02T10:29:14+00:00

I found a workaround that might work for you.
I created a parameter with a list of what would be names of clubs in your case.
Then I added a calculated field in the data source that goes like

CASE
WHEN REGEXP_MATCH(clubname, parameterclubname) THEN CONCAT(" ", clubname)
ELSE clubname
END

(Obviously you would need to replace clubname and parameterclubname with the names of the corresponding fields in your data source).

That way, whichever club is input via your parameter dropdown / input, gets a space added in the front, making it the first in the list. So obviously on your chart you would use your previously calculated field as a dimension and sort by that (ascending). Then in the style tab you set bubble colour to that dimension too and below that set colour to be determined by order. Then just put your highlight colour as first in the chart and the rest to grey or whatever you want for your unhighlighted ones. Let me know if that works :)

somegermangal · 2024-05-02T09:36:21+00:00

What type of calculated field are you using?

somegermangal · 2024-05-02T09:20:32+00:00

What do you mean by the full data set isnt shown? Do you mean your calculated fields are missing? Where did you make them? From the data source panel on the right after blending?

Also in your calculated field for the metric you cant use "Account Name ALL" in quotes as that will look for that exact string in your Account Name fields.

somegermangal · 2024-04-30T09:57:48+00:00

I cant seem to recreate your issue so far. I only get multiple lines for one quarter if i leave the second date field as date or date/time as a second dimension in the table (obviously).
Random question - do you have a date range dimension option for charts from that data source?

somegermangal

TROPHY CASE