how to create new column in pandas dataframe by indexing desirable parts of other columns
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
1
this is what i have:
fertility_rate =[3.97,3.68,3.14,2.73,2.27,2.02,1.86,1.70,1.68,1.32,1.31, 1.31,1.39,1.45,1.50,1.55,1.59]
year = ['1950-1955','1955-1960','1960-1965','1965-1970','1970-1975','1975-1980','1980-1985','1985-1990','1990-1995','1995-2000','2000-2005','2005-2010','2010-2015','2015-2020','2020-2025','2025-2030','2030-2035']
fertility = pd.DataFrame({'year': year, 'fertility': fertility_rate})
fertility.set_index('year', inplace=True)
fertility['fertility_high']=fertility['fertility'] +0.5
This code makes new column by adding 0.5 to every row in the column.
My goal is to for first 12 rows ( from 1955 to 2015 year) to copy values from a first column (fertility), and for 12+ rows to add 0.5.
python pandas
asked Nov 26 '18 at 19:34
waltexwqwaltexwq
103
add a comment |
1
this is what i have:
fertility_rate =[3.97,3.68,3.14,2.73,2.27,2.02,1.86,1.70,1.68,1.32,1.31, 1.31,1.39,1.45,1.50,1.55,1.59]
year = ['1950-1955','1955-1960','1960-1965','1965-1970','1970-1975','1975-1980','1980-1985','1985-1990','1990-1995','1995-2000','2000-2005','2005-2010','2010-2015','2015-2020','2020-2025','2025-2030','2030-2035']
fertility = pd.DataFrame({'year': year, 'fertility': fertility_rate})
fertility.set_index('year', inplace=True)
fertility['fertility_high']=fertility['fertility'] +0.5
This code makes new column by adding 0.5 to every row in the column.
My goal is to for first 12 rows ( from 1955 to 2015 year) to copy values from a first column (fertility), and for 12+ rows to add 0.5.
python pandas
asked Nov 26 '18 at 19:34
waltexwqwaltexwq
103
Use.ilocto index into both the rows and columns.
– Alexander Reynolds
Nov 26 '18 at 19:36
add a comment |
1
1
1
this is what i have:
fertility_rate =[3.97,3.68,3.14,2.73,2.27,2.02,1.86,1.70,1.68,1.32,1.31, 1.31,1.39,1.45,1.50,1.55,1.59]
year = ['1950-1955','1955-1960','1960-1965','1965-1970','1970-1975','1975-1980','1980-1985','1985-1990','1990-1995','1995-2000','2000-2005','2005-2010','2010-2015','2015-2020','2020-2025','2025-2030','2030-2035']
fertility = pd.DataFrame({'year': year, 'fertility': fertility_rate})
fertility.set_index('year', inplace=True)
fertility['fertility_high']=fertility['fertility'] +0.5
This code makes new column by adding 0.5 to every row in the column.
My goal is to for first 12 rows ( from 1955 to 2015 year) to copy values from a first column (fertility), and for 12+ rows to add 0.5.
python pandas
asked Nov 26 '18 at 19:34
waltexwqwaltexwq
103
this is what i have:
fertility_rate =[3.97,3.68,3.14,2.73,2.27,2.02,1.86,1.70,1.68,1.32,1.31, 1.31,1.39,1.45,1.50,1.55,1.59]
year = ['1950-1955','1955-1960','1960-1965','1965-1970','1970-1975','1975-1980','1980-1985','1985-1990','1990-1995','1995-2000','2000-2005','2005-2010','2010-2015','2015-2020','2020-2025','2025-2030','2030-2035']
fertility = pd.DataFrame({'year': year, 'fertility': fertility_rate})
fertility.set_index('year', inplace=True)
fertility['fertility_high']=fertility['fertility'] +0.5
This code makes new column by adding 0.5 to every row in the column.
My goal is to for first 12 rows ( from 1955 to 2015 year) to copy values from a first column (fertility), and for 12+ rows to add 0.5.
python pandas
python pandas
asked Nov 26 '18 at 19:34
waltexwqwaltexwq
103
asked Nov 26 '18 at 19:34
waltexwqwaltexwq
103
asked Nov 26 '18 at 19:34
waltexwqwaltexwq
103
asked Nov 26 '18 at 19:34
waltexwqwaltexwq
103
asked Nov 26 '18 at 19:34
waltexwqwaltexwq
103
103
Use.ilocto index into both the rows and columns.
– Alexander Reynolds
Nov 26 '18 at 19:36
add a comment |
Use.ilocto index into both the rows and columns.
– Alexander Reynolds
Nov 26 '18 at 19:36
Use
.iloc to index into both the rows and columns.– Alexander Reynolds
Nov 26 '18 at 19:36
Use
.iloc to index into both the rows and columns.– Alexander Reynolds
Nov 26 '18 at 19:36
add a comment |
1 Answer
1
active
oldest
votes
0
IIUC, you need same value as fertility in fertility high for the first 12 rows and increment by 0.5 for the rest
fertility['fertility_high']=fertility['fertility'].copy()
fertility.iloc[12:, 1]+=0.5
fertility fertility_high
year
1950-1955 3.97 3.97
1955-1960 3.68 3.68
1960-1965 3.14 3.14
1965-1970 2.73 2.73
1970-1975 2.27 2.27
1975-1980 2.02 2.02
1980-1985 1.86 1.86
1985-1990 1.70 1.70
1990-1995 1.68 1.68
1995-2000 1.32 1.32
2000-2005 1.31 1.31
2005-2010 1.31 1.31
2010-2015 1.39 1.89
2015-2020 1.45 1.95
2020-2025 1.50 2.00
2025-2030 1.55 2.05
2030-2035 1.59 2.09
answered Nov 26 '18 at 19:43
VaishaliVaishali
22.6k41438
thank you. that is it.
– waltexwq
Nov 26 '18 at 19:52
@waltexwq, great that it works. Do remember to upvote/accept the answer if it answers your query fully
– Vaishali
Nov 26 '18 at 19:54
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
});
}
});
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%2f53487851%2fhow-to-create-new-column-in-pandas-dataframe-by-indexing-desirable-parts-of-othe%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
IIUC, you need same value as fertility in fertility high for the first 12 rows and increment by 0.5 for the rest
fertility['fertility_high']=fertility['fertility'].copy()
fertility.iloc[12:, 1]+=0.5
fertility fertility_high
year
1950-1955 3.97 3.97
1955-1960 3.68 3.68
1960-1965 3.14 3.14
1965-1970 2.73 2.73
1970-1975 2.27 2.27
1975-1980 2.02 2.02
1980-1985 1.86 1.86
1985-1990 1.70 1.70
1990-1995 1.68 1.68
1995-2000 1.32 1.32
2000-2005 1.31 1.31
2005-2010 1.31 1.31
2010-2015 1.39 1.89
2015-2020 1.45 1.95
2020-2025 1.50 2.00
2025-2030 1.55 2.05
2030-2035 1.59 2.09
answered Nov 26 '18 at 19:43
VaishaliVaishali
22.6k41438
thank you. that is it.
– waltexwq
Nov 26 '18 at 19:52
@waltexwq, great that it works. Do remember to upvote/accept the answer if it answers your query fully
– Vaishali
Nov 26 '18 at 19:54
add a comment |
0
IIUC, you need same value as fertility in fertility high for the first 12 rows and increment by 0.5 for the rest
fertility['fertility_high']=fertility['fertility'].copy()
fertility.iloc[12:, 1]+=0.5
fertility fertility_high
year
1950-1955 3.97 3.97
1955-1960 3.68 3.68
1960-1965 3.14 3.14
1965-1970 2.73 2.73
1970-1975 2.27 2.27
1975-1980 2.02 2.02
1980-1985 1.86 1.86
1985-1990 1.70 1.70
1990-1995 1.68 1.68
1995-2000 1.32 1.32
2000-2005 1.31 1.31
2005-2010 1.31 1.31
2010-2015 1.39 1.89
2015-2020 1.45 1.95
2020-2025 1.50 2.00
2025-2030 1.55 2.05
2030-2035 1.59 2.09
answered Nov 26 '18 at 19:43
VaishaliVaishali
22.6k41438
thank you. that is it.
– waltexwq
Nov 26 '18 at 19:52
@waltexwq, great that it works. Do remember to upvote/accept the answer if it answers your query fully
– Vaishali
Nov 26 '18 at 19:54
add a comment |
0
0
0
IIUC, you need same value as fertility in fertility high for the first 12 rows and increment by 0.5 for the rest
fertility['fertility_high']=fertility['fertility'].copy()
fertility.iloc[12:, 1]+=0.5
fertility fertility_high
year
1950-1955 3.97 3.97
1955-1960 3.68 3.68
1960-1965 3.14 3.14
1965-1970 2.73 2.73
1970-1975 2.27 2.27
1975-1980 2.02 2.02
1980-1985 1.86 1.86
1985-1990 1.70 1.70
1990-1995 1.68 1.68
1995-2000 1.32 1.32
2000-2005 1.31 1.31
2005-2010 1.31 1.31
2010-2015 1.39 1.89
2015-2020 1.45 1.95
2020-2025 1.50 2.00
2025-2030 1.55 2.05
2030-2035 1.59 2.09
answered Nov 26 '18 at 19:43
VaishaliVaishali
22.6k41438
IIUC, you need same value as fertility in fertility high for the first 12 rows and increment by 0.5 for the rest
fertility['fertility_high']=fertility['fertility'].copy()
fertility.iloc[12:, 1]+=0.5
fertility fertility_high
year
1950-1955 3.97 3.97
1955-1960 3.68 3.68
1960-1965 3.14 3.14
1965-1970 2.73 2.73
1970-1975 2.27 2.27
1975-1980 2.02 2.02
1980-1985 1.86 1.86
1985-1990 1.70 1.70
1990-1995 1.68 1.68
1995-2000 1.32 1.32
2000-2005 1.31 1.31
2005-2010 1.31 1.31
2010-2015 1.39 1.89
2015-2020 1.45 1.95
2020-2025 1.50 2.00
2025-2030 1.55 2.05
2030-2035 1.59 2.09
answered Nov 26 '18 at 19:43
VaishaliVaishali
22.6k41438
answered Nov 26 '18 at 19:43
VaishaliVaishali
22.6k41438
answered Nov 26 '18 at 19:43
VaishaliVaishali
22.6k41438
answered Nov 26 '18 at 19:43
VaishaliVaishali
22.6k41438
22.6k41438
thank you. that is it.
– waltexwq
Nov 26 '18 at 19:52
@waltexwq, great that it works. Do remember to upvote/accept the answer if it answers your query fully
– Vaishali
Nov 26 '18 at 19:54
add a comment |
thank you. that is it.
– waltexwq
Nov 26 '18 at 19:52
@waltexwq, great that it works. Do remember to upvote/accept the answer if it answers your query fully
– Vaishali
Nov 26 '18 at 19:54
thank you. that is it.
– waltexwq
Nov 26 '18 at 19:52
thank you. that is it.
– waltexwq
Nov 26 '18 at 19:52
@waltexwq, great that it works. Do remember to upvote/accept the answer if it answers your query fully
– Vaishali
Nov 26 '18 at 19:54
@waltexwq, great that it works. Do remember to upvote/accept the answer if it answers your query fully
– Vaishali
Nov 26 '18 at 19:54
add a comment |
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%2f53487851%2fhow-to-create-new-column-in-pandas-dataframe-by-indexing-desirable-parts-of-othe%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
Use
.ilocto index into both the rows and columns.– Alexander Reynolds
Nov 26 '18 at 19:36