how to update column in data frame based on condition
$begingroup$
How to update column IsLCap column in dataframe based on Lvalue column whether it is capitilized or not.
df.loc[df.Lvalue.istitle(), 'IsLCap'] = 1 # need to be corrected
getting an error -AttributeError: 'Series' object has no attribute 'istitle'
python dataframe
asked 4 hours ago
SUHASINI KLSUHASINI KL
63
New contributor
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
add a comment |
$begingroup$
How to update column IsLCap column in dataframe based on Lvalue column whether it is capitilized or not.
df.loc[df.Lvalue.istitle(), 'IsLCap'] = 1 # need to be corrected
getting an error -AttributeError: 'Series' object has no attribute 'istitle'
python dataframe
asked 4 hours ago
SUHASINI KLSUHASINI KL
63
New contributor
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
add a comment |
$begingroup$
How to update column IsLCap column in dataframe based on Lvalue column whether it is capitilized or not.
df.loc[df.Lvalue.istitle(), 'IsLCap'] = 1 # need to be corrected
getting an error -AttributeError: 'Series' object has no attribute 'istitle'
python dataframe
asked 4 hours ago
SUHASINI KLSUHASINI KL
63
New contributor
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
How to update column IsLCap column in dataframe based on Lvalue column whether it is capitilized or not.
df.loc[df.Lvalue.istitle(), 'IsLCap'] = 1 # need to be corrected
getting an error -AttributeError: 'Series' object has no attribute 'istitle'
python dataframe
python dataframe
asked 4 hours ago
SUHASINI KLSUHASINI KL
63
New contributor
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
SUHASINI KLSUHASINI KL
63
New contributor
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
SUHASINI KLSUHASINI KL
63
New contributor
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 4 hours ago
SUHASINI KLSUHASINI KL
63
asked 4 hours ago
SUHASINI KLSUHASINI KL
63
63
New contributor
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
SUHASINI KL is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
$begingroup$
You access string functions with .str. This should work:
df.loc[df.Lvalue.str.istitle(), 'IsLCap'] = 1
Update
To check the length of the strings in the column you can use the string method .str.len:
df.loc[df.Lvalue.str.len() < 3, 'less_than_three'] = 1
Pandas Series string methods
answered 4 hours ago
mbassmbass
262
New contributor
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
$begingroup$
i need to check string length also, df.loc[len(df.Lvalue)<3, 'LlessThan3'] = 1 ## need to correct this. How can i do this
$endgroup$
– SUHASINI KL
3 hours ago
$begingroup$
I have updated my answer with a solution. If this works for you, you should accept/upvote the answer. @SUHASINIKL
$endgroup$
– mbass
3 hours ago
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
return StackExchange.using("mathjaxEditing", function () {
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
});
});
}, "mathjax-editing");
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
});
}
});
SUHASINI KL is a new contributor. Be nice, and check out our Code of Conduct.
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%2f44738%2fhow-to-update-column-in-data-frame-based-on-condition%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$
You access string functions with .str. This should work:
df.loc[df.Lvalue.str.istitle(), 'IsLCap'] = 1
Update
To check the length of the strings in the column you can use the string method .str.len:
df.loc[df.Lvalue.str.len() < 3, 'less_than_three'] = 1
Pandas Series string methods
answered 4 hours ago
mbassmbass
262
New contributor
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
$begingroup$
i need to check string length also, df.loc[len(df.Lvalue)<3, 'LlessThan3'] = 1 ## need to correct this. How can i do this
$endgroup$
– SUHASINI KL
3 hours ago
$begingroup$
I have updated my answer with a solution. If this works for you, you should accept/upvote the answer. @SUHASINIKL
$endgroup$
– mbass
3 hours ago
add a comment |
$begingroup$
You access string functions with .str. This should work:
df.loc[df.Lvalue.str.istitle(), 'IsLCap'] = 1
Update
To check the length of the strings in the column you can use the string method .str.len:
df.loc[df.Lvalue.str.len() < 3, 'less_than_three'] = 1
Pandas Series string methods
answered 4 hours ago
mbassmbass
262
New contributor
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
$begingroup$
i need to check string length also, df.loc[len(df.Lvalue)<3, 'LlessThan3'] = 1 ## need to correct this. How can i do this
$endgroup$
– SUHASINI KL
3 hours ago
$begingroup$
I have updated my answer with a solution. If this works for you, you should accept/upvote the answer. @SUHASINIKL
$endgroup$
– mbass
3 hours ago
add a comment |
$begingroup$
You access string functions with .str. This should work:
df.loc[df.Lvalue.str.istitle(), 'IsLCap'] = 1
Update
To check the length of the strings in the column you can use the string method .str.len:
df.loc[df.Lvalue.str.len() < 3, 'less_than_three'] = 1
Pandas Series string methods
answered 4 hours ago
mbassmbass
262
New contributor
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$endgroup$
You access string functions with .str. This should work:
df.loc[df.Lvalue.str.istitle(), 'IsLCap'] = 1
Update
To check the length of the strings in the column you can use the string method .str.len:
df.loc[df.Lvalue.str.len() < 3, 'less_than_three'] = 1
Pandas Series string methods
answered 4 hours ago
mbassmbass
262
New contributor
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 3 hours ago
answered 4 hours ago
mbassmbass
262
New contributor
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 4 hours ago
mbassmbass
262
answered 4 hours ago
mbassmbass
262
262
New contributor
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
mbass is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
$begingroup$
i need to check string length also, df.loc[len(df.Lvalue)<3, 'LlessThan3'] = 1 ## need to correct this. How can i do this
$endgroup$
– SUHASINI KL
3 hours ago
$begingroup$
I have updated my answer with a solution. If this works for you, you should accept/upvote the answer. @SUHASINIKL
$endgroup$
– mbass
3 hours ago
add a comment |
$begingroup$
i need to check string length also, df.loc[len(df.Lvalue)<3, 'LlessThan3'] = 1 ## need to correct this. How can i do this
$endgroup$
– SUHASINI KL
3 hours ago
$begingroup$
I have updated my answer with a solution. If this works for you, you should accept/upvote the answer. @SUHASINIKL
$endgroup$
– mbass
3 hours ago
$begingroup$
i need to check string length also, df.loc[len(df.Lvalue)<3, 'LlessThan3'] = 1 ## need to correct this. How can i do this
$endgroup$
– SUHASINI KL
3 hours ago
$begingroup$
i need to check string length also, df.loc[len(df.Lvalue)<3, 'LlessThan3'] = 1 ## need to correct this. How can i do this
$endgroup$
– SUHASINI KL
3 hours ago
$begingroup$
I have updated my answer with a solution. If this works for you, you should accept/upvote the answer. @SUHASINIKL
$endgroup$
– mbass
3 hours ago
$begingroup$
I have updated my answer with a solution. If this works for you, you should accept/upvote the answer. @SUHASINIKL
$endgroup$
– mbass
3 hours ago
add a comment |
SUHASINI KL is a new contributor. Be nice, and check out our Code of Conduct.
SUHASINI KL is a new contributor. Be nice, and check out our Code of Conduct.
SUHASINI KL is a new contributor. Be nice, and check out our Code of Conduct.
SUHASINI KL is a new contributor. Be nice, and check out our Code of Conduct.
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%2f44738%2fhow-to-update-column-in-data-frame-based-on-condition%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
