Write a function that returns the count of the unique answers to all of the questions in a dataset

Question

For example, after filtering the entire dataset to only questions containing the word "King", we could then find all of the unique answers to those questions.

I filtered by using the following code:

`def lower1(x):
   x.lower()

 filter_dataset = lambda x:all(x) in jeopardy.Question.apply(lower1) 
 print(filter_dataset(['King','England']))`

The above code is printing True instead of printing the rows of jeopardy['Question'] with the keywords 'King' and 'England'.

That is the first problem.

Now I want to count the unique answers to the jeopardy['Question']

Here is the sample data frame

Now I want to create a function that does the count of the unique answers. I wrote the following code:

  `def unique_counts():
      print(jeopardy['Answer'].unique().value_counts())
   unique_counts()`

Which is giving me the following error:

AttributeError: 'numpy.ndarray' object has no attribute 'value_counts'

What do you mean by failed?? – Karthik Bhandary Apr 08 '21 at 06:59 — Karthik Bhandary, Apr 08 '21 at 06:59
Added better dupe for check by substrings. – jezrael Apr 08 '21 at 07:23 — jezrael, Apr 08 '21 at 07:23

Mayank Porwal · Answer 1 · 2021-04-08T07:48:16.810

1

Use Series.str.contains:

jeopardy[jeopardy['Question'].str.contains('|'.join(['King','England']))]

edited Apr 08 '21 at 07:48

answered Apr 08 '21 at 06:58

Mayank Porwal

33,470
8
37
58

Answer was closed. – jezrael Apr 08 '21 at 07:00
Let's wait for OP to comeback if this is what he wants. If he wants something else, question might need to be reopened. – Mayank Porwal Apr 08 '21 at 07:02
I don't know why but the question was closed. – Karthik Bhandary Apr 08 '21 at 07:03
@KarthikBhandary - Is `isin` what need ? Or something else? – jezrael Apr 08 '21 at 07:04
I am saying that I want to create a dataset out of the `jeopardy.Question` I used the `isin` but it created an empty dataset. – Karthik Bhandary Apr 08 '21 at 07:10
Hey @KarthikBhandary. Please share some sample dataframe with expected output in your question. This would help us understand it better and answer. – Mayank Porwal Apr 08 '21 at 07:11
I added the data frame and edited the question for better understanding. – Karthik Bhandary Apr 08 '21 at 07:25
@KarthikBhandary Check my updated answer. Let me know if this helps. – Mayank Porwal Apr 08 '21 at 07:27
It is printing the `Answer` column I want the `Question` column as well – Karthik Bhandary Apr 08 '21 at 07:34
It will get you all the columns of the dataframe. Is `Question` column not printed? – Mayank Porwal Apr 08 '21 at 07:41
Not sure. OP has not confirmed back. You have anyway closed the question as dupe. Let it be. I'll update you if it needs to be re-opened. – Mayank Porwal Apr 08 '21 at 07:50
@MayankPorwal - yes, after more clear added new [dupe](https://stackoverflow.com/a/26578218/2901002). So accepting means dupe, if need OP something else, please reopen. – jezrael Apr 08 '21 at 07:59
Sure will do. Thanks. – Mayank Porwal Apr 08 '21 at 07:59
It was only printing the Answer column – Karthik Bhandary Apr 09 '21 at 00:10

Write a function that returns the count of the unique answers to all of the questions in a dataset

1 Answers1