Python - Applying title() function to values in column
I've done a few methods for python on my data frame. However I'm wondering why my function is not working correctly and why it does not seem to be applying correctly, here is my code followed by the corresponding screenshot:
def clean_belfast_data(df):
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name'].str.title().inplace=True
return df
python pandas
edited Nov 11 at 18:51
user69453
602723
asked Nov 11 at 16:45
ComSci Student
433
add a comment |
I've done a few methods for python on my data frame. However I'm wondering why my function is not working correctly and why it does not seem to be applying correctly, here is my code followed by the corresponding screenshot:
def clean_belfast_data(df):
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name'].str.title().inplace=True
return df
python pandas
edited Nov 11 at 18:51
user69453
602723
asked Nov 11 at 16:45
ComSci Student
433
add a comment |
I've done a few methods for python on my data frame. However I'm wondering why my function is not working correctly and why it does not seem to be applying correctly, here is my code followed by the corresponding screenshot:
def clean_belfast_data(df):
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name'].str.title().inplace=True
return df
python pandas
edited Nov 11 at 18:51
user69453
602723
asked Nov 11 at 16:45
ComSci Student
433
I've done a few methods for python on my data frame. However I'm wondering why my function is not working correctly and why it does not seem to be applying correctly, here is my code followed by the corresponding screenshot:
def clean_belfast_data(df):
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name'].str.title().inplace=True
return df
python pandas
python pandas
edited Nov 11 at 18:51
user69453
602723
asked Nov 11 at 16:45
ComSci Student
433
edited Nov 11 at 18:51
user69453
602723
asked Nov 11 at 16:45
ComSci Student
433
edited Nov 11 at 18:51
user69453
602723
edited Nov 11 at 18:51
user69453
602723
edited Nov 11 at 18:51
user69453
602723
602723
asked Nov 11 at 16:45
ComSci Student
433
asked Nov 11 at 16:45
ComSci Student
433
asked Nov 11 at 16:45
ComSci Student
433
433
add a comment |
add a comment |
3 Answers
3
active
oldest
votes
Change
df['Ward Name'].str.title().inplace=True
to
df['Ward Name'] = df['Ward Name'].str.title()
The line df['Ward Name'].str.title().inplace=True is invalid python/pandas. I'm not sure why it runs without error, but it's not doing what you mean to do.
answered Nov 11 at 16:56
Peter Leimbigler
3,7041415
add a comment |
You have two thing need to change ,
df['Ward Name'].str.title().inplace=True
this is wrong .
also , do not forget to assign it back , and usually we do not using inplace = True to modify the original data directly
def clean_belfast_data(df1):
df=df1.copy()
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name']=df['Ward Name'].str.title()
return df
CrimeData_1=clean_belfast_data(crimeDate)
answered Nov 11 at 17:04
W-B
101k73163
add a comment |
No need to create a function. Your operations are not stored, That's your problem.
df['Ward Name']= df['Ward Name'].dropna()
Then
df['Ward Name'] = df['Ward Name'].str.title()
answered Nov 11 at 17:14
Herc01
1036
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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%2fstackoverflow.com%2fquestions%2f53250929%2fpython-applying-title-function-to-values-in-column%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
Change
df['Ward Name'].str.title().inplace=True
to
df['Ward Name'] = df['Ward Name'].str.title()
The line df['Ward Name'].str.title().inplace=True is invalid python/pandas. I'm not sure why it runs without error, but it's not doing what you mean to do.
answered Nov 11 at 16:56
Peter Leimbigler
3,7041415
add a comment |
Change
df['Ward Name'].str.title().inplace=True
to
df['Ward Name'] = df['Ward Name'].str.title()
The line df['Ward Name'].str.title().inplace=True is invalid python/pandas. I'm not sure why it runs without error, but it's not doing what you mean to do.
answered Nov 11 at 16:56
Peter Leimbigler
3,7041415
add a comment |
Change
df['Ward Name'].str.title().inplace=True
to
df['Ward Name'] = df['Ward Name'].str.title()
The line df['Ward Name'].str.title().inplace=True is invalid python/pandas. I'm not sure why it runs without error, but it's not doing what you mean to do.
answered Nov 11 at 16:56
Peter Leimbigler
3,7041415
Change
df['Ward Name'].str.title().inplace=True
to
df['Ward Name'] = df['Ward Name'].str.title()
The line df['Ward Name'].str.title().inplace=True is invalid python/pandas. I'm not sure why it runs without error, but it's not doing what you mean to do.
answered Nov 11 at 16:56
Peter Leimbigler
3,7041415
answered Nov 11 at 16:56
Peter Leimbigler
3,7041415
answered Nov 11 at 16:56
Peter Leimbigler
3,7041415
answered Nov 11 at 16:56
Peter Leimbigler
3,7041415
3,7041415
add a comment |
add a comment |
You have two thing need to change ,
df['Ward Name'].str.title().inplace=True
this is wrong .
also , do not forget to assign it back , and usually we do not using inplace = True to modify the original data directly
def clean_belfast_data(df1):
df=df1.copy()
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name']=df['Ward Name'].str.title()
return df
CrimeData_1=clean_belfast_data(crimeDate)
answered Nov 11 at 17:04
W-B
101k73163
add a comment |
You have two thing need to change ,
df['Ward Name'].str.title().inplace=True
this is wrong .
also , do not forget to assign it back , and usually we do not using inplace = True to modify the original data directly
def clean_belfast_data(df1):
df=df1.copy()
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name']=df['Ward Name'].str.title()
return df
CrimeData_1=clean_belfast_data(crimeDate)
answered Nov 11 at 17:04
W-B
101k73163
add a comment |
You have two thing need to change ,
df['Ward Name'].str.title().inplace=True
this is wrong .
also , do not forget to assign it back , and usually we do not using inplace = True to modify the original data directly
def clean_belfast_data(df1):
df=df1.copy()
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name']=df['Ward Name'].str.title()
return df
CrimeData_1=clean_belfast_data(crimeDate)
answered Nov 11 at 17:04
W-B
101k73163
You have two thing need to change ,
df['Ward Name'].str.title().inplace=True
this is wrong .
also , do not forget to assign it back , and usually we do not using inplace = True to modify the original data directly
def clean_belfast_data(df1):
df=df1.copy()
df.dropna(subset=['Ward Name'], inplace=True)
df.reset_index(drop=True, inplace=True)
#Perhaps I can't use inplace for this.
df['Ward Name']=df['Ward Name'].str.title()
return df
CrimeData_1=clean_belfast_data(crimeDate)
answered Nov 11 at 17:04
W-B
101k73163
answered Nov 11 at 17:04
W-B
101k73163
answered Nov 11 at 17:04
W-B
101k73163
answered Nov 11 at 17:04
W-B
101k73163
101k73163
add a comment |
add a comment |
No need to create a function. Your operations are not stored, That's your problem.
df['Ward Name']= df['Ward Name'].dropna()
Then
df['Ward Name'] = df['Ward Name'].str.title()
answered Nov 11 at 17:14
Herc01
1036
add a comment |
No need to create a function. Your operations are not stored, That's your problem.
df['Ward Name']= df['Ward Name'].dropna()
Then
df['Ward Name'] = df['Ward Name'].str.title()
answered Nov 11 at 17:14
Herc01
1036
add a comment |
No need to create a function. Your operations are not stored, That's your problem.
df['Ward Name']= df['Ward Name'].dropna()
Then
df['Ward Name'] = df['Ward Name'].str.title()
answered Nov 11 at 17:14
Herc01
1036
No need to create a function. Your operations are not stored, That's your problem.
df['Ward Name']= df['Ward Name'].dropna()
Then
df['Ward Name'] = df['Ward Name'].str.title()
answered Nov 11 at 17:14
Herc01
1036
answered Nov 11 at 17:14
Herc01
1036
answered Nov 11 at 17:14
Herc01
1036
answered Nov 11 at 17:14
Herc01
1036
1036
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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.
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%2fstackoverflow.com%2fquestions%2f53250929%2fpython-applying-title-function-to-values-in-column%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
