how to use index to call other dataframe data
enter image description hereI have created a following dataframe and would like to use the index stock code to call other data and add a new column and 'price'
RSI
Stock
HOYA 61.940859
HKSE 61.657187
BABA 54.881989
HSI 53.664616
Galaxy 52.561760
and another dataframe that have the latest closing price of twenty stocks call 'Close'
How do I add a column to my first dataframe?
when my input
df['Stock']
#this return an error ??
And Also how do I add a new column to df with the latest closing price (ignoring the NaN)?? Please see the attached screen shot on my other dataframe.
thanks I am new to python and trying to apply it to my day to day work.
enter image description here
python pandas dataframe financial
asked Nov 19 '18 at 3:06
Allan CheungAllan Cheung
11
add a comment |
enter image description hereI have created a following dataframe and would like to use the index stock code to call other data and add a new column and 'price'
RSI
Stock
HOYA 61.940859
HKSE 61.657187
BABA 54.881989
HSI 53.664616
Galaxy 52.561760
and another dataframe that have the latest closing price of twenty stocks call 'Close'
How do I add a column to my first dataframe?
when my input
df['Stock']
#this return an error ??
And Also how do I add a new column to df with the latest closing price (ignoring the NaN)?? Please see the attached screen shot on my other dataframe.
thanks I am new to python and trying to apply it to my day to day work.
enter image description here
python pandas dataframe financial
asked Nov 19 '18 at 3:06
Allan CheungAllan Cheung
11
missing attachment. And what have you tried so far?
– Tilo
Nov 19 '18 at 3:45
add a comment |
enter image description hereI have created a following dataframe and would like to use the index stock code to call other data and add a new column and 'price'
RSI
Stock
HOYA 61.940859
HKSE 61.657187
BABA 54.881989
HSI 53.664616
Galaxy 52.561760
and another dataframe that have the latest closing price of twenty stocks call 'Close'
How do I add a column to my first dataframe?
when my input
df['Stock']
#this return an error ??
And Also how do I add a new column to df with the latest closing price (ignoring the NaN)?? Please see the attached screen shot on my other dataframe.
thanks I am new to python and trying to apply it to my day to day work.
enter image description here
python pandas dataframe financial
asked Nov 19 '18 at 3:06
Allan CheungAllan Cheung
11
enter image description hereI have created a following dataframe and would like to use the index stock code to call other data and add a new column and 'price'
RSI
Stock
HOYA 61.940859
HKSE 61.657187
BABA 54.881989
HSI 53.664616
Galaxy 52.561760
and another dataframe that have the latest closing price of twenty stocks call 'Close'
How do I add a column to my first dataframe?
when my input
df['Stock']
#this return an error ??
And Also how do I add a new column to df with the latest closing price (ignoring the NaN)?? Please see the attached screen shot on my other dataframe.
thanks I am new to python and trying to apply it to my day to day work.
enter image description here
python pandas dataframe financial
python pandas dataframe financial
asked Nov 19 '18 at 3:06
Allan CheungAllan Cheung
11
asked Nov 19 '18 at 3:06
Allan CheungAllan Cheung
11
edited Nov 19 '18 at 6:43
Allan Cheung
asked Nov 19 '18 at 3:06
Allan CheungAllan Cheung
11
asked Nov 19 '18 at 3:06
Allan CheungAllan Cheung
11
asked Nov 19 '18 at 3:06
Allan CheungAllan Cheung
11
11
missing attachment. And what have you tried so far?
– Tilo
Nov 19 '18 at 3:45
add a comment |
missing attachment. And what have you tried so far?
– Tilo
Nov 19 '18 at 3:45
missing attachment. And what have you tried so far?
– Tilo
Nov 19 '18 at 3:45
missing attachment. And what have you tried so far?
– Tilo
Nov 19 '18 at 3:45
add a comment |
1 Answer
1
active
oldest
votes
As per your screenshot, the name of your first DataFrame is TOP so use TOP['Price'] to add a new column named 'Price'.
To have the latest closing price of HSI:
p_of_hsi = close.iloc[-2][1]
-2 for the second last row and 1 for first column
Now assign this value of HSI in TOP DataFrame
TOP['Price'][3] = p_of_hsi
answered Nov 19 '18 at 7:20
Shambhavi JhaShambhavi Jha
13
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 '18 at 11:02
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%2f53367783%2fhow-to-use-index-to-call-other-dataframe-data%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
As per your screenshot, the name of your first DataFrame is TOP so use TOP['Price'] to add a new column named 'Price'.
To have the latest closing price of HSI:
p_of_hsi = close.iloc[-2][1]
-2 for the second last row and 1 for first column
Now assign this value of HSI in TOP DataFrame
TOP['Price'][3] = p_of_hsi
answered Nov 19 '18 at 7:20
Shambhavi JhaShambhavi Jha
13
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 '18 at 11:02
add a comment |
As per your screenshot, the name of your first DataFrame is TOP so use TOP['Price'] to add a new column named 'Price'.
To have the latest closing price of HSI:
p_of_hsi = close.iloc[-2][1]
-2 for the second last row and 1 for first column
Now assign this value of HSI in TOP DataFrame
TOP['Price'][3] = p_of_hsi
answered Nov 19 '18 at 7:20
Shambhavi JhaShambhavi Jha
13
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 '18 at 11:02
add a comment |
As per your screenshot, the name of your first DataFrame is TOP so use TOP['Price'] to add a new column named 'Price'.
To have the latest closing price of HSI:
p_of_hsi = close.iloc[-2][1]
-2 for the second last row and 1 for first column
Now assign this value of HSI in TOP DataFrame
TOP['Price'][3] = p_of_hsi
answered Nov 19 '18 at 7:20
Shambhavi JhaShambhavi Jha
13
As per your screenshot, the name of your first DataFrame is TOP so use TOP['Price'] to add a new column named 'Price'.
To have the latest closing price of HSI:
p_of_hsi = close.iloc[-2][1]
-2 for the second last row and 1 for first column
Now assign this value of HSI in TOP DataFrame
TOP['Price'][3] = p_of_hsi
answered Nov 19 '18 at 7:20
Shambhavi JhaShambhavi Jha
13
edited Nov 19 '18 at 8:15
answered Nov 19 '18 at 7:20
Shambhavi JhaShambhavi Jha
13
answered Nov 19 '18 at 7:20
Shambhavi JhaShambhavi Jha
13
answered Nov 19 '18 at 7:20
Shambhavi JhaShambhavi Jha
13
13
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 '18 at 11:02
add a comment |
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 '18 at 11:02
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 '18 at 11:02
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 '18 at 11:02
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%2f53367783%2fhow-to-use-index-to-call-other-dataframe-data%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
missing attachment. And what have you tried so far?
– Tilo
Nov 19 '18 at 3:45