Replace items inside a list in a column in pandas dataframe? The Next CEO of Stack OverflowFinding the index of an item given a list containing it in PythonHow to randomly select an item from a list?Selecting multiple columns in a pandas dataframeRenaming columns in pandasFilter dataframe rows if value in column is in a set list of valuesAdding new column to existing DataFrame in Python pandasDelete column from pandas DataFrame by column nameHow to iterate over rows in a DataFrame in Pandas?Select rows from a DataFrame based on values in a column in pandasGet list from pandas DataFrame column headers
Why do we say “un seul M” and not “une seule M” even though M is a “consonne”?
How can I separate the number from the unit in argument?
Is a distribution that is normal, but highly skewed, considered Gaussian?
Man transported from Alternate World into ours by a Neutrino Detector
The sum of any ten consecutive numbers from a fibonacci sequence is divisible by 11
Ising model simulation
Calculating discount not working
Can this transistor (2n2222) take 6V on emitter-base? Am I reading datasheet incorrectly?
How seriously should I take size and weight limits of hand luggage?
Salesforce opportunity stages
Is it correct to say moon starry nights?
Creating a script with console commands
How do I secure a TV wall mount?
Is it okay to majorly distort historical facts while writing a fiction story?
Is it possible to create a QR code using text?
How to unfasten electrical subpanel attached with ramset
Is this a new Fibonacci Identity?
Early programmable calculators with RS-232
Can a PhD from a non-TU9 German university become a professor in a TU9 university?
Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact
How to compactly explain secondary and tertiary characters without resorting to stereotypes?
What day is it again?
"Eavesdropping" vs "Listen in on"
How can a day be of 24 hours?
Replace items inside a list in a column in pandas dataframe?
The Next CEO of Stack OverflowFinding the index of an item given a list containing it in PythonHow to randomly select an item from a list?Selecting multiple columns in a pandas dataframeRenaming columns in pandasFilter dataframe rows if value in column is in a set list of valuesAdding new column to existing DataFrame in Python pandasDelete column from pandas DataFrame by column nameHow to iterate over rows in a DataFrame in Pandas?Select rows from a DataFrame based on values in a column in pandasGet list from pandas DataFrame column headers
Suppose I have a pandas df:
import pandas as pd
ex = pd.DataFrame('Title': ['Data Scientist', 'Data Analyst', 'Data Engineer'],
'Skills': [['Python', 'R ', 'C ', 'C++'], ['Python', 'R,', 'C ', 'C++'], ['Python', 'R ', 'C,', 'C++']])
If I want to replace R[space] and R, with R and C[space] and C, with C, how should I do it?
python regex pandas
asked Mar 7 at 19:41
katiekatie
10728
add a comment |
Suppose I have a pandas df:
import pandas as pd
ex = pd.DataFrame('Title': ['Data Scientist', 'Data Analyst', 'Data Engineer'],
'Skills': [['Python', 'R ', 'C ', 'C++'], ['Python', 'R,', 'C ', 'C++'], ['Python', 'R ', 'C,', 'C++']])
If I want to replace R[space] and R, with R and C[space] and C, with C, how should I do it?
python regex pandas
asked Mar 7 at 19:41
katiekatie
10728
add a comment |
Suppose I have a pandas df:
import pandas as pd
ex = pd.DataFrame('Title': ['Data Scientist', 'Data Analyst', 'Data Engineer'],
'Skills': [['Python', 'R ', 'C ', 'C++'], ['Python', 'R,', 'C ', 'C++'], ['Python', 'R ', 'C,', 'C++']])
If I want to replace R[space] and R, with R and C[space] and C, with C, how should I do it?
python regex pandas
asked Mar 7 at 19:41
katiekatie
10728
Suppose I have a pandas df:
import pandas as pd
ex = pd.DataFrame('Title': ['Data Scientist', 'Data Analyst', 'Data Engineer'],
'Skills': [['Python', 'R ', 'C ', 'C++'], ['Python', 'R,', 'C ', 'C++'], ['Python', 'R ', 'C,', 'C++']])
If I want to replace R[space] and R, with R and C[space] and C, with C, how should I do it?
python regex pandas
python regex pandas
asked Mar 7 at 19:41
katiekatie
10728
asked Mar 7 at 19:41
katiekatie
10728
edited Mar 7 at 19:52
katie
asked Mar 7 at 19:41
katiekatie
10728
asked Mar 7 at 19:41
katiekatie
10728
asked Mar 7 at 19:41
katiekatie
10728
10728
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Using strip
ex.Skills=[[y.strip() for y in x] for x in ex.Skills]
ex
Out[755]:
Title Skills
0 Data Scientist [Python, R, C, C++]
1 Data Analyst [Python, R, C, C++]
2 Data Engineer [Python, R, C, C++]
answered Mar 7 at 19:44
Wen-BenWen-Ben
122k83571
Thanks for answering! What if I have a comma in the string afterCorR(something like thisC,orR,)? (Just modified my example df for the question?)
– katie
Mar 7 at 19:54
1
@katie[[y.replace(',','').strip() for y in x] for x in ex.Skills]
– Wen-Ben
Mar 7 at 19:58
add a comment |
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%2f55051645%2freplace-items-inside-a-list-in-a-column-in-pandas-dataframe%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
Using strip
ex.Skills=[[y.strip() for y in x] for x in ex.Skills]
ex
Out[755]:
Title Skills
0 Data Scientist [Python, R, C, C++]
1 Data Analyst [Python, R, C, C++]
2 Data Engineer [Python, R, C, C++]
answered Mar 7 at 19:44
Wen-BenWen-Ben
122k83571
Thanks for answering! What if I have a comma in the string afterCorR(something like thisC,orR,)? (Just modified my example df for the question?)
– katie
Mar 7 at 19:54
1
@katie[[y.replace(',','').strip() for y in x] for x in ex.Skills]
– Wen-Ben
Mar 7 at 19:58
add a comment |
Using strip
ex.Skills=[[y.strip() for y in x] for x in ex.Skills]
ex
Out[755]:
Title Skills
0 Data Scientist [Python, R, C, C++]
1 Data Analyst [Python, R, C, C++]
2 Data Engineer [Python, R, C, C++]
answered Mar 7 at 19:44
Wen-BenWen-Ben
122k83571
Thanks for answering! What if I have a comma in the string afterCorR(something like thisC,orR,)? (Just modified my example df for the question?)
– katie
Mar 7 at 19:54
1
@katie[[y.replace(',','').strip() for y in x] for x in ex.Skills]
– Wen-Ben
Mar 7 at 19:58
add a comment |
Using strip
ex.Skills=[[y.strip() for y in x] for x in ex.Skills]
ex
Out[755]:
Title Skills
0 Data Scientist [Python, R, C, C++]
1 Data Analyst [Python, R, C, C++]
2 Data Engineer [Python, R, C, C++]
answered Mar 7 at 19:44
Wen-BenWen-Ben
122k83571
Using strip
ex.Skills=[[y.strip() for y in x] for x in ex.Skills]
ex
Out[755]:
Title Skills
0 Data Scientist [Python, R, C, C++]
1 Data Analyst [Python, R, C, C++]
2 Data Engineer [Python, R, C, C++]
answered Mar 7 at 19:44
Wen-BenWen-Ben
122k83571
answered Mar 7 at 19:44
Wen-BenWen-Ben
122k83571
answered Mar 7 at 19:44
Wen-BenWen-Ben
122k83571
answered Mar 7 at 19:44
Wen-BenWen-Ben
122k83571
122k83571
Thanks for answering! What if I have a comma in the string afterCorR(something like thisC,orR,)? (Just modified my example df for the question?)
– katie
Mar 7 at 19:54
1
@katie[[y.replace(',','').strip() for y in x] for x in ex.Skills]
– Wen-Ben
Mar 7 at 19:58
add a comment |
Thanks for answering! What if I have a comma in the string afterCorR(something like thisC,orR,)? (Just modified my example df for the question?)
– katie
Mar 7 at 19:54
1
@katie[[y.replace(',','').strip() for y in x] for x in ex.Skills]
– Wen-Ben
Mar 7 at 19:58
Thanks for answering! What if I have a comma in the string after
C or R (something like this C, or R,)? (Just modified my example df for the question?)– katie
Mar 7 at 19:54
Thanks for answering! What if I have a comma in the string after
C or R (something like this C, or R,)? (Just modified my example df for the question?)– katie
Mar 7 at 19:54
1
1
@katie
[[y.replace(',','').strip() for y in x] for x in ex.Skills]– Wen-Ben
Mar 7 at 19:58
@katie
[[y.replace(',','').strip() for y in x] for x in ex.Skills]– Wen-Ben
Mar 7 at 19:58
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.
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%2f55051645%2freplace-items-inside-a-list-in-a-column-in-pandas-dataframe%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
