Replace a value in a column if that value appears only once Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) 2019 Moderator Election Q&A - Questionnaire 2019 Community Moderator Election ResultsReplacing column values in PandasCreate a new column based on two columns from two different dataframesPandas how to fill missing values in one column if the values in another column are equaltesting new data in modelPandas column count mismatch after insert into dataframeHow to replace a part string value of a column using another columnIQR Score outliers detection in PythonChange values of consecutive repeating letters in pandas columnhow to update column in data frame based on conditionAssigning a variable in Python using analogue of '.format()'
What is the definining line between a helicopter and a drone a person can ride in?
Protagonist's race is hidden - should I reveal it?
What documents does someone with a long-term visa need to travel to another Schengen country?
Why did Bronn offer to be Tyrion Lannister's champion in trial by combat?
What is the ongoing value of the Kanban board to the developers as opposed to management
A German immigrant ancestor has a "Registration Affidavit of Alien Enemy" on file. What does that mean exactly?
false 'Security alert' from Google - every login generates mails from 'no-reply@accounts.google.com'
Why is one lightbulb in a string illuminated?
Putting Ant-Man on house arrest
How to get a single big right brace?
Is Bran literally the world's memory?
Determine the generator of an ideal of ring of integers
Why do people think Winterfell crypts is the safest place for women, children & old people?
Pointing to problems without suggesting solutions
Does using the Inspiration rules for character defects encourage My Guy Syndrome?
Is it OK if I do not take the receipt in Germany?
lm and glm function in R
How to create a command for the "strange m" symbol in latex?
Why isn't everyone flabbergasted about Bran's "gift"?
What could prevent concentrated local exploration?
Salesforce - multiple pre production environments
Converting a text document with special format to Pandas DataFrame
Married in secret, can marital status in passport be changed at a later date?
Etymology of 見舞い
Replace a value in a column if that value appears only once
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern)
2019 Moderator Election Q&A - Questionnaire
2019 Community Moderator Election ResultsReplacing column values in PandasCreate a new column based on two columns from two different dataframesPandas how to fill missing values in one column if the values in another column are equaltesting new data in modelPandas column count mismatch after insert into dataframeHow to replace a part string value of a column using another columnIQR Score outliers detection in PythonChange values of consecutive repeating letters in pandas columnhow to update column in data frame based on conditionAssigning a variable in Python using analogue of '.format()'
$begingroup$
I have a dataframe, I want to replace the values in one column by "other" if the value count of that value in that column is exactly 1
i Food_group
0 Flake
1 Flake
2 Flake
3 Almond
4 Drink
5 Drink
6 Flake
I have tried,
data["food_group"] = data.food_group.apply(lambda x: "other" if x.value_counts()==1 else x)
I got error
AttributeError: 'str' object has no attribute 'value_counts'
python
asked yesterday
KHAN irfanKHAN irfan
11910
$endgroup$
add a comment |
$begingroup$
I have a dataframe, I want to replace the values in one column by "other" if the value count of that value in that column is exactly 1
i Food_group
0 Flake
1 Flake
2 Flake
3 Almond
4 Drink
5 Drink
6 Flake
I have tried,
data["food_group"] = data.food_group.apply(lambda x: "other" if x.value_counts()==1 else x)
I got error
AttributeError: 'str' object has no attribute 'value_counts'
python
asked yesterday
KHAN irfanKHAN irfan
11910
$endgroup$
add a comment |
$begingroup$
I have a dataframe, I want to replace the values in one column by "other" if the value count of that value in that column is exactly 1
i Food_group
0 Flake
1 Flake
2 Flake
3 Almond
4 Drink
5 Drink
6 Flake
I have tried,
data["food_group"] = data.food_group.apply(lambda x: "other" if x.value_counts()==1 else x)
I got error
AttributeError: 'str' object has no attribute 'value_counts'
python
asked yesterday
KHAN irfanKHAN irfan
11910
$endgroup$
I have a dataframe, I want to replace the values in one column by "other" if the value count of that value in that column is exactly 1
i Food_group
0 Flake
1 Flake
2 Flake
3 Almond
4 Drink
5 Drink
6 Flake
I have tried,
data["food_group"] = data.food_group.apply(lambda x: "other" if x.value_counts()==1 else x)
I got error
AttributeError: 'str' object has no attribute 'value_counts'
python
python
asked yesterday
KHAN irfanKHAN irfan
11910
asked yesterday
KHAN irfanKHAN irfan
11910
asked yesterday
KHAN irfanKHAN irfan
11910
asked yesterday
KHAN irfanKHAN irfan
11910
asked yesterday
KHAN irfanKHAN irfan
11910
11910
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
It is easier if you store the value count separately to avoid redoing it inside the apply loop. You can do it like this:
food_count = data["food_group"].value_counts()
data["food_group"] = data["food_group"].apply(lambda x: "other" if food_count[x]==1 else x)
answered yesterday
Simon LarssonSimon Larsson
1,100214
$endgroup$
$begingroup$
Have you tried the code? it does not work
$endgroup$
– KHAN irfan
yesterday
$begingroup$
Test it now. :) Tried on another dataset and forgot to change back to "food_group"
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Tested it on your data now, so it should work.
$endgroup$
– Simon Larsson
yesterday
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "557"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f49669%2freplace-a-value-in-a-column-if-that-value-appears-only-once%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
$begingroup$
It is easier if you store the value count separately to avoid redoing it inside the apply loop. You can do it like this:
food_count = data["food_group"].value_counts()
data["food_group"] = data["food_group"].apply(lambda x: "other" if food_count[x]==1 else x)
answered yesterday
Simon LarssonSimon Larsson
1,100214
$endgroup$
$begingroup$
Have you tried the code? it does not work
$endgroup$
– KHAN irfan
yesterday
$begingroup$
Test it now. :) Tried on another dataset and forgot to change back to "food_group"
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Tested it on your data now, so it should work.
$endgroup$
– Simon Larsson
yesterday
add a comment |
$begingroup$
It is easier if you store the value count separately to avoid redoing it inside the apply loop. You can do it like this:
food_count = data["food_group"].value_counts()
data["food_group"] = data["food_group"].apply(lambda x: "other" if food_count[x]==1 else x)
answered yesterday
Simon LarssonSimon Larsson
1,100214
$endgroup$
$begingroup$
Have you tried the code? it does not work
$endgroup$
– KHAN irfan
yesterday
$begingroup$
Test it now. :) Tried on another dataset and forgot to change back to "food_group"
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Tested it on your data now, so it should work.
$endgroup$
– Simon Larsson
yesterday
add a comment |
$begingroup$
It is easier if you store the value count separately to avoid redoing it inside the apply loop. You can do it like this:
food_count = data["food_group"].value_counts()
data["food_group"] = data["food_group"].apply(lambda x: "other" if food_count[x]==1 else x)
answered yesterday
Simon LarssonSimon Larsson
1,100214
$endgroup$
It is easier if you store the value count separately to avoid redoing it inside the apply loop. You can do it like this:
food_count = data["food_group"].value_counts()
data["food_group"] = data["food_group"].apply(lambda x: "other" if food_count[x]==1 else x)
answered yesterday
Simon LarssonSimon Larsson
1,100214
edited yesterday
answered yesterday
Simon LarssonSimon Larsson
1,100214
answered yesterday
Simon LarssonSimon Larsson
1,100214
answered yesterday
Simon LarssonSimon Larsson
1,100214
1,100214
$begingroup$
Have you tried the code? it does not work
$endgroup$
– KHAN irfan
yesterday
$begingroup$
Test it now. :) Tried on another dataset and forgot to change back to "food_group"
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Tested it on your data now, so it should work.
$endgroup$
– Simon Larsson
yesterday
add a comment |
$begingroup$
Have you tried the code? it does not work
$endgroup$
– KHAN irfan
yesterday
$begingroup$
Test it now. :) Tried on another dataset and forgot to change back to "food_group"
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Tested it on your data now, so it should work.
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Have you tried the code? it does not work
$endgroup$
– KHAN irfan
yesterday
$begingroup$
Have you tried the code? it does not work
$endgroup$
– KHAN irfan
yesterday
$begingroup$
Test it now. :) Tried on another dataset and forgot to change back to "food_group"
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Test it now. :) Tried on another dataset and forgot to change back to "food_group"
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Tested it on your data now, so it should work.
$endgroup$
– Simon Larsson
yesterday
$begingroup$
Tested it on your data now, so it should work.
$endgroup$
– Simon Larsson
yesterday
add a comment |
Thanks for contributing an answer to Data Science Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f49669%2freplace-a-value-in-a-column-if-that-value-appears-only-once%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
