Mixing
Adding & Removing string components in a tibble
-3
I have a tibble of stock name:
A tibble: 239 x 3
symbole entreprise secteur
<chr> <chr> <chr>
1 TSX : AAV Advantage Oil & Gas Énergie
2 TSX : ABX Barrick Gold Matériaux
3 TSX : ACM.A Astral Media Consommation Cyclique
4 TSX : ACO.X Atco Utilitaires
5 TSX : AEM Agnico-Eagle Matériaux
6 TSX : AGF.B La Société de Gestion AGF Finance
7 TSX : AGI Alamos Gold Matériaux
8 TSX : AGU Agrium Matériaux
9 TSX : AIM Aimia Consommation Cyclique
10 TSX : ALA AltaGas Énergie
# ... with 229 more rows
I want to remove the "TSX:" part in the column name, add ".TO" to each name and replace the "." in some names by "-" .
So that the name "TSE:ACO.X" becomes "ACO-X.TO" .....etc....etc....
I tried several solution and the only thing I get is a column full of dot!
r
edited Nov 20 '18 at 20:28
m0nhawk
15.4k83160
asked Nov 20 '18 at 20:27
JacquesJacques
12
add a comment |
-3
I have a tibble of stock name:
A tibble: 239 x 3
symbole entreprise secteur
<chr> <chr> <chr>
1 TSX : AAV Advantage Oil & Gas Énergie
2 TSX : ABX Barrick Gold Matériaux
3 TSX : ACM.A Astral Media Consommation Cyclique
4 TSX : ACO.X Atco Utilitaires
5 TSX : AEM Agnico-Eagle Matériaux
6 TSX : AGF.B La Société de Gestion AGF Finance
7 TSX : AGI Alamos Gold Matériaux
8 TSX : AGU Agrium Matériaux
9 TSX : AIM Aimia Consommation Cyclique
10 TSX : ALA AltaGas Énergie
# ... with 229 more rows
I want to remove the "TSX:" part in the column name, add ".TO" to each name and replace the "." in some names by "-" .
So that the name "TSE:ACO.X" becomes "ACO-X.TO" .....etc....etc....
I tried several solution and the only thing I get is a column full of dot!
r
edited Nov 20 '18 at 20:28
m0nhawk
15.4k83160
asked Nov 20 '18 at 20:27
JacquesJacques
12
Show exactly what you tried so we can help you fix it.
– MrFlick
Nov 20 '18 at 20:42
add a comment |
-3
-3
-3
I have a tibble of stock name:
A tibble: 239 x 3
symbole entreprise secteur
<chr> <chr> <chr>
1 TSX : AAV Advantage Oil & Gas Énergie
2 TSX : ABX Barrick Gold Matériaux
3 TSX : ACM.A Astral Media Consommation Cyclique
4 TSX : ACO.X Atco Utilitaires
5 TSX : AEM Agnico-Eagle Matériaux
6 TSX : AGF.B La Société de Gestion AGF Finance
7 TSX : AGI Alamos Gold Matériaux
8 TSX : AGU Agrium Matériaux
9 TSX : AIM Aimia Consommation Cyclique
10 TSX : ALA AltaGas Énergie
# ... with 229 more rows
I want to remove the "TSX:" part in the column name, add ".TO" to each name and replace the "." in some names by "-" .
So that the name "TSE:ACO.X" becomes "ACO-X.TO" .....etc....etc....
I tried several solution and the only thing I get is a column full of dot!
r
edited Nov 20 '18 at 20:28
m0nhawk
15.4k83160
asked Nov 20 '18 at 20:27
JacquesJacques
12
I have a tibble of stock name:
A tibble: 239 x 3
symbole entreprise secteur
<chr> <chr> <chr>
1 TSX : AAV Advantage Oil & Gas Énergie
2 TSX : ABX Barrick Gold Matériaux
3 TSX : ACM.A Astral Media Consommation Cyclique
4 TSX : ACO.X Atco Utilitaires
5 TSX : AEM Agnico-Eagle Matériaux
6 TSX : AGF.B La Société de Gestion AGF Finance
7 TSX : AGI Alamos Gold Matériaux
8 TSX : AGU Agrium Matériaux
9 TSX : AIM Aimia Consommation Cyclique
10 TSX : ALA AltaGas Énergie
# ... with 229 more rows
I want to remove the "TSX:" part in the column name, add ".TO" to each name and replace the "." in some names by "-" .
So that the name "TSE:ACO.X" becomes "ACO-X.TO" .....etc....etc....
I tried several solution and the only thing I get is a column full of dot!
r
r
edited Nov 20 '18 at 20:28
m0nhawk
15.4k83160
asked Nov 20 '18 at 20:27
JacquesJacques
12
edited Nov 20 '18 at 20:28
m0nhawk
15.4k83160
asked Nov 20 '18 at 20:27
JacquesJacques
12
edited Nov 20 '18 at 20:28
m0nhawk
15.4k83160
edited Nov 20 '18 at 20:28
m0nhawk
15.4k83160
edited Nov 20 '18 at 20:28
m0nhawk
15.4k83160
15.4k83160
asked Nov 20 '18 at 20:27
JacquesJacques
12
asked Nov 20 '18 at 20:27
JacquesJacques
12
asked Nov 20 '18 at 20:27
JacquesJacques
12
12
Show exactly what you tried so we can help you fix it.
– MrFlick
Nov 20 '18 at 20:42
add a comment |
Show exactly what you tried so we can help you fix it.
– MrFlick
Nov 20 '18 at 20:42
Show exactly what you tried so we can help you fix it.
– MrFlick
Nov 20 '18 at 20:42
Show exactly what you tried so we can help you fix it.
– MrFlick
Nov 20 '18 at 20:42
add a comment |
1 Answer
1
active
oldest
votes
0
This can be done with a series of gsub/pastes, first removing the TSX:, then replacing the periods, then appending .TO. Because of the way mutate works, we can put them all as a series of tag=value statements inside one mutate:
library(dplyr)
df %>% mutate(symbole=gsub("TSX \: ","",symbole),
symbole=gsub("\.","-",symbole),
symbole=paste0(symbole,".TO"))
answered Nov 20 '18 at 20:40
iodiod
3,7992722
That method add the "-" and the ".TO" but does not remove the "TSX :" in front of the stock names.
– Jacques
Nov 20 '18 at 21:04
Works on my side... Can you give me the output just for `as.vector(df$symbole)'?
– iod
Nov 20 '18 at 21:07
or better yet, add thedput(df)to your original question.
– iod
Nov 20 '18 at 21:08
I tried using str_remove and str_replace. If I try to remove TSX, it also remove the X in some names.....and I don't whant that!
– Jacques
Nov 20 '18 at 21:14
as.vector(tsx$symbole) gives me a vector of names: [1] "TSX : AAV" etc...
– Jacques
Nov 20 '18 at 21:15
|
show 5 more comments
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
});
}
});
draft saved
draft discarded
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%2f53401018%2fadding-removing-string-components-in-a-tibble%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
0
This can be done with a series of gsub/pastes, first removing the TSX:, then replacing the periods, then appending .TO. Because of the way mutate works, we can put them all as a series of tag=value statements inside one mutate:
library(dplyr)
df %>% mutate(symbole=gsub("TSX \: ","",symbole),
symbole=gsub("\.","-",symbole),
symbole=paste0(symbole,".TO"))
answered Nov 20 '18 at 20:40
iodiod
3,7992722
That method add the "-" and the ".TO" but does not remove the "TSX :" in front of the stock names.
– Jacques
Nov 20 '18 at 21:04
Works on my side... Can you give me the output just for `as.vector(df$symbole)'?
– iod
Nov 20 '18 at 21:07
or better yet, add thedput(df)to your original question.
– iod
Nov 20 '18 at 21:08
I tried using str_remove and str_replace. If I try to remove TSX, it also remove the X in some names.....and I don't whant that!
– Jacques
Nov 20 '18 at 21:14
as.vector(tsx$symbole) gives me a vector of names: [1] "TSX : AAV" etc...
– Jacques
Nov 20 '18 at 21:15
|
show 5 more comments
0
This can be done with a series of gsub/pastes, first removing the TSX:, then replacing the periods, then appending .TO. Because of the way mutate works, we can put them all as a series of tag=value statements inside one mutate:
library(dplyr)
df %>% mutate(symbole=gsub("TSX \: ","",symbole),
symbole=gsub("\.","-",symbole),
symbole=paste0(symbole,".TO"))
answered Nov 20 '18 at 20:40
iodiod
3,7992722
That method add the "-" and the ".TO" but does not remove the "TSX :" in front of the stock names.
– Jacques
Nov 20 '18 at 21:04
Works on my side... Can you give me the output just for `as.vector(df$symbole)'?
– iod
Nov 20 '18 at 21:07
or better yet, add thedput(df)to your original question.
– iod
Nov 20 '18 at 21:08
I tried using str_remove and str_replace. If I try to remove TSX, it also remove the X in some names.....and I don't whant that!
– Jacques
Nov 20 '18 at 21:14
as.vector(tsx$symbole) gives me a vector of names: [1] "TSX : AAV" etc...
– Jacques
Nov 20 '18 at 21:15
|
show 5 more comments
0
0
0
This can be done with a series of gsub/pastes, first removing the TSX:, then replacing the periods, then appending .TO. Because of the way mutate works, we can put them all as a series of tag=value statements inside one mutate:
library(dplyr)
df %>% mutate(symbole=gsub("TSX \: ","",symbole),
symbole=gsub("\.","-",symbole),
symbole=paste0(symbole,".TO"))
answered Nov 20 '18 at 20:40
iodiod
3,7992722
This can be done with a series of gsub/pastes, first removing the TSX:, then replacing the periods, then appending .TO. Because of the way mutate works, we can put them all as a series of tag=value statements inside one mutate:
library(dplyr)
df %>% mutate(symbole=gsub("TSX \: ","",symbole),
symbole=gsub("\.","-",symbole),
symbole=paste0(symbole,".TO"))
answered Nov 20 '18 at 20:40
iodiod
3,7992722
edited Nov 20 '18 at 21:50
answered Nov 20 '18 at 20:40
iodiod
3,7992722
answered Nov 20 '18 at 20:40
iodiod
3,7992722
answered Nov 20 '18 at 20:40
iodiod
3,7992722
3,7992722
That method add the "-" and the ".TO" but does not remove the "TSX :" in front of the stock names.
– Jacques
Nov 20 '18 at 21:04
Works on my side... Can you give me the output just for `as.vector(df$symbole)'?
– iod
Nov 20 '18 at 21:07
or better yet, add thedput(df)to your original question.
– iod
Nov 20 '18 at 21:08
I tried using str_remove and str_replace. If I try to remove TSX, it also remove the X in some names.....and I don't whant that!
– Jacques
Nov 20 '18 at 21:14
as.vector(tsx$symbole) gives me a vector of names: [1] "TSX : AAV" etc...
– Jacques
Nov 20 '18 at 21:15
|
show 5 more comments
That method add the "-" and the ".TO" but does not remove the "TSX :" in front of the stock names.
– Jacques
Nov 20 '18 at 21:04
Works on my side... Can you give me the output just for `as.vector(df$symbole)'?
– iod
Nov 20 '18 at 21:07
or better yet, add thedput(df)to your original question.
– iod
Nov 20 '18 at 21:08
I tried using str_remove and str_replace. If I try to remove TSX, it also remove the X in some names.....and I don't whant that!
– Jacques
Nov 20 '18 at 21:14
as.vector(tsx$symbole) gives me a vector of names: [1] "TSX : AAV" etc...
– Jacques
Nov 20 '18 at 21:15
That method add the "-" and the ".TO" but does not remove the "TSX :" in front of the stock names.
– Jacques
Nov 20 '18 at 21:04
That method add the "-" and the ".TO" but does not remove the "TSX :" in front of the stock names.
– Jacques
Nov 20 '18 at 21:04
Works on my side... Can you give me the output just for `as.vector(df$symbole)'?
– iod
Nov 20 '18 at 21:07
Works on my side... Can you give me the output just for `as.vector(df$symbole)'?
– iod
Nov 20 '18 at 21:07
or better yet, add the
dput(df) to your original question.– iod
Nov 20 '18 at 21:08
or better yet, add the
dput(df) to your original question.– iod
Nov 20 '18 at 21:08
I tried using str_remove and str_replace. If I try to remove TSX, it also remove the X in some names.....and I don't whant that!
– Jacques
Nov 20 '18 at 21:14
I tried using str_remove and str_replace. If I try to remove TSX, it also remove the X in some names.....and I don't whant that!
– Jacques
Nov 20 '18 at 21:14
as.vector(tsx$symbole) gives me a vector of names: [1] "TSX : AAV" etc...
– Jacques
Nov 20 '18 at 21:15
as.vector(tsx$symbole) gives me a vector of names: [1] "TSX : AAV" etc...
– Jacques
Nov 20 '18 at 21:15
|
show 5 more comments
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53401018%2fadding-removing-string-components-in-a-tibble%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
Show exactly what you tried so we can help you fix it.
– MrFlick
Nov 20 '18 at 20:42