how to use index to call other dataframe data
up vote
0
down vote
favorite
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 at 3:06
Allan Cheung
11
add a comment |
up vote
0
down vote
favorite
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 at 3:06
Allan Cheung
11
missing attachment. And what have you tried so far?
– Tilo
Nov 19 at 3:45
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
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 at 3:06
Allan 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 at 3:06
Allan Cheung
11
asked Nov 19 at 3:06
Allan Cheung
11
edited Nov 19 at 6:43
asked Nov 19 at 3:06
Allan Cheung
11
asked Nov 19 at 3:06
Allan Cheung
11
asked Nov 19 at 3:06
Allan Cheung
11
11
missing attachment. And what have you tried so far?
– Tilo
Nov 19 at 3:45
add a comment |
missing attachment. And what have you tried so far?
– Tilo
Nov 19 at 3:45
missing attachment. And what have you tried so far?
– Tilo
Nov 19 at 3:45
missing attachment. And what have you tried so far?
– Tilo
Nov 19 at 3:45
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
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 at 7:20
Shambhavi Jha
13
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 at 11:02
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
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 at 7:20
Shambhavi Jha
13
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 at 11:02
add a comment |
up vote
0
down vote
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 at 7:20
Shambhavi Jha
13
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 at 11:02
add a comment |
up vote
0
down vote
up vote
0
down vote
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 at 7:20
Shambhavi 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 at 7:20
Shambhavi Jha
13
edited Nov 19 at 8:15
answered Nov 19 at 7:20
Shambhavi Jha
13
answered Nov 19 at 7:20
Shambhavi Jha
13
answered Nov 19 at 7:20
Shambhavi Jha
13
13
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 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 at 11:02
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 at 11:02
thank you!! sorry for the confusion I have try to make the question clearer below
– Allan Cheung
Nov 21 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.
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%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 at 3:45