Mixing
Convert a pandas pivot table to 2D array
I had a 2D data like this:
"X" "Y" "Intensity"
1000 10 75
1000 20 65
2000 30 80
2000 20 60
2000 40 55
3000 10 65
3000 20 45
4000 30 80
Using the code:
df.pivot(index='X', columns='Y', values='Intensity')
I converted it to a pandas table like this:
"Y" 10 20 30 40
"X"
1000 75 65 NaN NaN
2000 NaN 60 80 55
3000 65 45 NaN NaN
4000 NaN NaN 80 NaN
Using the code:
np.interpolate()
And then interpolated it to fill some of the values like this:
"Y" 10 20 30 40
"X"
1000 75 65 NaN NaN
2000 55 60 80 55
3000 65 45 60 NaN
4000 NaN 60 80 NaN
Now I want it to be converted back to the initial 2D data format in order to plot a contour map.
I hope this is sufficient information to answer my query. Can anyone help me with this, please?
python arrays pandas dataframe
asked Nov 21 '18 at 16:29
Sukanya KambojSukanya Kamboj
153
add a comment |
I had a 2D data like this:
"X" "Y" "Intensity"
1000 10 75
1000 20 65
2000 30 80
2000 20 60
2000 40 55
3000 10 65
3000 20 45
4000 30 80
Using the code:
df.pivot(index='X', columns='Y', values='Intensity')
I converted it to a pandas table like this:
"Y" 10 20 30 40
"X"
1000 75 65 NaN NaN
2000 NaN 60 80 55
3000 65 45 NaN NaN
4000 NaN NaN 80 NaN
Using the code:
np.interpolate()
And then interpolated it to fill some of the values like this:
"Y" 10 20 30 40
"X"
1000 75 65 NaN NaN
2000 55 60 80 55
3000 65 45 60 NaN
4000 NaN 60 80 NaN
Now I want it to be converted back to the initial 2D data format in order to plot a contour map.
I hope this is sufficient information to answer my query. Can anyone help me with this, please?
python arrays pandas dataframe
asked Nov 21 '18 at 16:29
Sukanya KambojSukanya Kamboj
153
add a comment |
I had a 2D data like this:
"X" "Y" "Intensity"
1000 10 75
1000 20 65
2000 30 80
2000 20 60
2000 40 55
3000 10 65
3000 20 45
4000 30 80
Using the code:
df.pivot(index='X', columns='Y', values='Intensity')
I converted it to a pandas table like this:
"Y" 10 20 30 40
"X"
1000 75 65 NaN NaN
2000 NaN 60 80 55
3000 65 45 NaN NaN
4000 NaN NaN 80 NaN
Using the code:
np.interpolate()
And then interpolated it to fill some of the values like this:
"Y" 10 20 30 40
"X"
1000 75 65 NaN NaN
2000 55 60 80 55
3000 65 45 60 NaN
4000 NaN 60 80 NaN
Now I want it to be converted back to the initial 2D data format in order to plot a contour map.
I hope this is sufficient information to answer my query. Can anyone help me with this, please?
python arrays pandas dataframe
asked Nov 21 '18 at 16:29
Sukanya KambojSukanya Kamboj
153
I had a 2D data like this:
"X" "Y" "Intensity"
1000 10 75
1000 20 65
2000 30 80
2000 20 60
2000 40 55
3000 10 65
3000 20 45
4000 30 80
Using the code:
df.pivot(index='X', columns='Y', values='Intensity')
I converted it to a pandas table like this:
"Y" 10 20 30 40
"X"
1000 75 65 NaN NaN
2000 NaN 60 80 55
3000 65 45 NaN NaN
4000 NaN NaN 80 NaN
Using the code:
np.interpolate()
And then interpolated it to fill some of the values like this:
"Y" 10 20 30 40
"X"
1000 75 65 NaN NaN
2000 55 60 80 55
3000 65 45 60 NaN
4000 NaN 60 80 NaN
Now I want it to be converted back to the initial 2D data format in order to plot a contour map.
I hope this is sufficient information to answer my query. Can anyone help me with this, please?
python arrays pandas dataframe
python arrays pandas dataframe
asked Nov 21 '18 at 16:29
Sukanya KambojSukanya Kamboj
153
asked Nov 21 '18 at 16:29
Sukanya KambojSukanya Kamboj
153
asked Nov 21 '18 at 16:29
Sukanya KambojSukanya Kamboj
153
asked Nov 21 '18 at 16:29
Sukanya KambojSukanya Kamboj
153
asked Nov 21 '18 at 16:29
Sukanya KambojSukanya Kamboj
153
153
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You can do:
df.stack().reset_index()
answered Nov 21 '18 at 16:54
Toby PettyToby Petty
706412
Thank you! It works. :)
– Sukanya Kamboj
Nov 22 '18 at 15:55
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%2f53416552%2fconvert-a-pandas-pivot-table-to-2d-array%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
You can do:
df.stack().reset_index()
answered Nov 21 '18 at 16:54
Toby PettyToby Petty
706412
Thank you! It works. :)
– Sukanya Kamboj
Nov 22 '18 at 15:55
add a comment |
You can do:
df.stack().reset_index()
answered Nov 21 '18 at 16:54
Toby PettyToby Petty
706412
Thank you! It works. :)
– Sukanya Kamboj
Nov 22 '18 at 15:55
add a comment |
You can do:
df.stack().reset_index()
answered Nov 21 '18 at 16:54
Toby PettyToby Petty
706412
You can do:
df.stack().reset_index()
answered Nov 21 '18 at 16:54
Toby PettyToby Petty
706412
answered Nov 21 '18 at 16:54
Toby PettyToby Petty
706412
answered Nov 21 '18 at 16:54
Toby PettyToby Petty
706412
answered Nov 21 '18 at 16:54
Toby PettyToby Petty
706412
706412
Thank you! It works. :)
– Sukanya Kamboj
Nov 22 '18 at 15:55
add a comment |
Thank you! It works. :)
– Sukanya Kamboj
Nov 22 '18 at 15:55
Thank you! It works. :)
– Sukanya Kamboj
Nov 22 '18 at 15:55
Thank you! It works. :)
– Sukanya Kamboj
Nov 22 '18 at 15:55
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%2f53416552%2fconvert-a-pandas-pivot-table-to-2d-array%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
