Replace roman numerals and create a variable with year-quarter date
I want to adjust a column to use it as a date variable in a chart. However the variable contains Roman numerals as month and on the other hand a year displayed in Arabic numerals.
Factor w/ 34 levels "I-III 2010","I-III 2011",..
I'd like to transform these values into the following pattern (year-quarter ): 2010-1 , 2011-1.
I tried the following, but not sure if it's the best way to approach my problem.
df$var = gsub("I-III", "1 -", df$var)
df$var = gsub("IV-VI", "2 -", df$var)
df$var = gsub("VII-IX","3 -", df$var)
df$var = gsub("X-XII","4 -", df$var)
What would you recommend?
Thanks
r roman-numerals
edited Nov 11 '18 at 22:33
camille
6,94531427
asked Nov 11 '18 at 21:03
Kamil Sawczak
84
|
show 1 more comment
I want to adjust a column to use it as a date variable in a chart. However the variable contains Roman numerals as month and on the other hand a year displayed in Arabic numerals.
Factor w/ 34 levels "I-III 2010","I-III 2011",..
I'd like to transform these values into the following pattern (year-quarter ): 2010-1 , 2011-1.
I tried the following, but not sure if it's the best way to approach my problem.
df$var = gsub("I-III", "1 -", df$var)
df$var = gsub("IV-VI", "2 -", df$var)
df$var = gsub("VII-IX","3 -", df$var)
df$var = gsub("X-XII","4 -", df$var)
What would you recommend?
Thanks
r roman-numerals
edited Nov 11 '18 at 22:33
camille
6,94531427
asked Nov 11 '18 at 21:03
Kamil Sawczak
84
Why do you want2010-1when there are two roman numerals (1 and 3)
– hrbrmstr
Nov 11 '18 at 21:06
Presumable I-III == Jan-Mar == 1st quarter. @Kamil Sawczak Please show the pattern for all four quarters and what you have tried so far.
– Henrik
Nov 11 '18 at 21:08
because it is showing a range from Jan to March what is actually a quarter 1
– Kamil Sawczak
Nov 11 '18 at 21:11
1
@Henrik I updated the discription
– Kamil Sawczak
Nov 11 '18 at 21:42
1
What's wrong with the way you do it already?
– dww
Nov 12 '18 at 0:41
|
show 1 more comment
I want to adjust a column to use it as a date variable in a chart. However the variable contains Roman numerals as month and on the other hand a year displayed in Arabic numerals.
Factor w/ 34 levels "I-III 2010","I-III 2011",..
I'd like to transform these values into the following pattern (year-quarter ): 2010-1 , 2011-1.
I tried the following, but not sure if it's the best way to approach my problem.
df$var = gsub("I-III", "1 -", df$var)
df$var = gsub("IV-VI", "2 -", df$var)
df$var = gsub("VII-IX","3 -", df$var)
df$var = gsub("X-XII","4 -", df$var)
What would you recommend?
Thanks
r roman-numerals
edited Nov 11 '18 at 22:33
camille
6,94531427
asked Nov 11 '18 at 21:03
Kamil Sawczak
84
I want to adjust a column to use it as a date variable in a chart. However the variable contains Roman numerals as month and on the other hand a year displayed in Arabic numerals.
Factor w/ 34 levels "I-III 2010","I-III 2011",..
I'd like to transform these values into the following pattern (year-quarter ): 2010-1 , 2011-1.
I tried the following, but not sure if it's the best way to approach my problem.
df$var = gsub("I-III", "1 -", df$var)
df$var = gsub("IV-VI", "2 -", df$var)
df$var = gsub("VII-IX","3 -", df$var)
df$var = gsub("X-XII","4 -", df$var)
What would you recommend?
Thanks
r roman-numerals
r roman-numerals
edited Nov 11 '18 at 22:33
camille
6,94531427
asked Nov 11 '18 at 21:03
Kamil Sawczak
84
edited Nov 11 '18 at 22:33
camille
6,94531427
asked Nov 11 '18 at 21:03
Kamil Sawczak
84
edited Nov 11 '18 at 22:33
camille
6,94531427
edited Nov 11 '18 at 22:33
camille
6,94531427
edited Nov 11 '18 at 22:33
camille
6,94531427
6,94531427
asked Nov 11 '18 at 21:03
Kamil Sawczak
84
asked Nov 11 '18 at 21:03
Kamil Sawczak
84
asked Nov 11 '18 at 21:03
Kamil Sawczak
84
84
Why do you want2010-1when there are two roman numerals (1 and 3)
– hrbrmstr
Nov 11 '18 at 21:06
Presumable I-III == Jan-Mar == 1st quarter. @Kamil Sawczak Please show the pattern for all four quarters and what you have tried so far.
– Henrik
Nov 11 '18 at 21:08
because it is showing a range from Jan to March what is actually a quarter 1
– Kamil Sawczak
Nov 11 '18 at 21:11
1
@Henrik I updated the discription
– Kamil Sawczak
Nov 11 '18 at 21:42
1
What's wrong with the way you do it already?
– dww
Nov 12 '18 at 0:41
|
show 1 more comment
Why do you want2010-1when there are two roman numerals (1 and 3)
– hrbrmstr
Nov 11 '18 at 21:06
Presumable I-III == Jan-Mar == 1st quarter. @Kamil Sawczak Please show the pattern for all four quarters and what you have tried so far.
– Henrik
Nov 11 '18 at 21:08
because it is showing a range from Jan to March what is actually a quarter 1
– Kamil Sawczak
Nov 11 '18 at 21:11
1
@Henrik I updated the discription
– Kamil Sawczak
Nov 11 '18 at 21:42
1
What's wrong with the way you do it already?
– dww
Nov 12 '18 at 0:41
Why do you want
2010-1 when there are two roman numerals (1 and 3)– hrbrmstr
Nov 11 '18 at 21:06
Why do you want
2010-1 when there are two roman numerals (1 and 3)– hrbrmstr
Nov 11 '18 at 21:06
Presumable I-III == Jan-Mar == 1st quarter. @Kamil Sawczak Please show the pattern for all four quarters and what you have tried so far.
– Henrik
Nov 11 '18 at 21:08
Presumable I-III == Jan-Mar == 1st quarter. @Kamil Sawczak Please show the pattern for all four quarters and what you have tried so far.
– Henrik
Nov 11 '18 at 21:08
because it is showing a range from Jan to March what is actually a quarter 1
– Kamil Sawczak
Nov 11 '18 at 21:11
because it is showing a range from Jan to March what is actually a quarter 1
– Kamil Sawczak
Nov 11 '18 at 21:11
1
1
@Henrik I updated the discription
– Kamil Sawczak
Nov 11 '18 at 21:42
@Henrik I updated the discription
– Kamil Sawczak
Nov 11 '18 at 21:42
1
1
What's wrong with the way you do it already?
– dww
Nov 12 '18 at 0:41
What's wrong with the way you do it already?
– dww
Nov 12 '18 at 0:41
|
show 1 more comment
0
active
oldest
votes
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%2f53253209%2freplace-roman-numerals-and-create-a-variable-with-year-quarter-date%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53253209%2freplace-roman-numerals-and-create-a-variable-with-year-quarter-date%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
Why do you want
2010-1when there are two roman numerals (1 and 3)– hrbrmstr
Nov 11 '18 at 21:06
Presumable I-III == Jan-Mar == 1st quarter. @Kamil Sawczak Please show the pattern for all four quarters and what you have tried so far.
– Henrik
Nov 11 '18 at 21:08
because it is showing a range from Jan to March what is actually a quarter 1
– Kamil Sawczak
Nov 11 '18 at 21:11
1
@Henrik I updated the discription
– Kamil Sawczak
Nov 11 '18 at 21:42
1
What's wrong with the way you do it already?
– dww
Nov 12 '18 at 0:41