Convert dataframe into dictionary2019 Community Moderator ElectionHow to merge two dictionaries in a single expression?How do I sort a list of dictionaries by a value of the dictionary?What is the best way to iterate over a dictionary?Convert two lists into a dictionary in PythonConvert bytes to a string?How do I sort a dictionary by value?Add new keys to a dictionary?Check if a given key already exists in a dictionaryIterating over dictionaries using 'for' loopsHow to remove a key from a Python dictionary?
Print a physical multiplication table
How to make healing in an exploration game interesting
Bacteria contamination inside a thermos bottle
Meme-controlled people
Why do newer 737s use two different styles of split winglets?
How do you talk to someone whose loved one is dying?
What is the adequate fee for a reveal operation?
How to pronounce "I ♥ Huckabees"?
Math equation in non italic font
Why does overlay work only on the first tcolorbox?
Do I need life insurance if I can cover my own funeral costs?
Why is a white electrical wire connected to 2 black wires?
Is it good practice to use Linear Least-Squares with SMA?
What did “the good wine” (τὸν καλὸν οἶνον) mean in John 2:10?
Can I use USB data pins as a power source?
What is "focus distance lower/upper" and how is it different from depth of field?
Is honey really a supersaturated solution? Does heating to un-crystalize redissolve it or melt it?
How do I hide Chekhov's Gun?
Brexit - No Deal Rejection
Could the Saturn V actually have launched astronauts around Venus?
Does .bashrc contain syntax errors?
Is there a hypothetical scenario that would make Earth uninhabitable for humans, but not for (the majority of) other animals?
Professor being mistaken for a grad student
Why is the President allowed to veto a cancellation of emergency powers?
Convert dataframe into dictionary
2019 Community Moderator ElectionHow to merge two dictionaries in a single expression?How do I sort a list of dictionaries by a value of the dictionary?What is the best way to iterate over a dictionary?Convert two lists into a dictionary in PythonConvert bytes to a string?How do I sort a dictionary by value?Add new keys to a dictionary?Check if a given key already exists in a dictionaryIterating over dictionaries using 'for' loopsHow to remove a key from a Python dictionary?
I have a dataframe and i want it to select a few columns and convert it into Dictionary in the a certain manner
Dataframe:
and here's the output I want
20: [4.6, 4.3, 4.3, 20],
21: [4.6, 4.3, 4.3, 21],
22: [6.0, 5.6, 9.0, 22],
23: [8.75, 5.6, 6.6, 23]
I have tried this
items_dic = data[["Length","Width","Height","Pid" ]].set_index('Pid').T.to_dict('list')
items_dic = 20: [4.6, 4.3, 4.3],
21: [4.6, 4.3, 4.3],
22: [6.0, 5.6, 9.0],
23: [8.75, 5.6, 6.6]
but this does not include Pid in the list of values
Can someone explain why ?
python python-3.x pandas dictionary
edited Mar 12 at 6:26
jezrael
347k25304379
asked Mar 12 at 6:16
Rahul SharmaRahul Sharma
1638
New contributor
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I have a dataframe and i want it to select a few columns and convert it into Dictionary in the a certain manner
Dataframe:
and here's the output I want
20: [4.6, 4.3, 4.3, 20],
21: [4.6, 4.3, 4.3, 21],
22: [6.0, 5.6, 9.0, 22],
23: [8.75, 5.6, 6.6, 23]
I have tried this
items_dic = data[["Length","Width","Height","Pid" ]].set_index('Pid').T.to_dict('list')
items_dic = 20: [4.6, 4.3, 4.3],
21: [4.6, 4.3, 4.3],
22: [6.0, 5.6, 9.0],
23: [8.75, 5.6, 6.6]
but this does not include Pid in the list of values
Can someone explain why ?
python python-3.x pandas dictionary
edited Mar 12 at 6:26
jezrael
347k25304379
asked Mar 12 at 6:16
Rahul SharmaRahul Sharma
1638
New contributor
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Please, write the dataframe in proper format, not in picture.
– pistol2myhead
Mar 12 at 6:19
1
I am sorry but I am fairly new to SO and I don't know how to do that
– Rahul Sharma
Mar 12 at 6:22
2
drop=Falseinset_indexis what you need
– Sreeram TP
Mar 12 at 6:25
add a comment |
I have a dataframe and i want it to select a few columns and convert it into Dictionary in the a certain manner
Dataframe:
and here's the output I want
20: [4.6, 4.3, 4.3, 20],
21: [4.6, 4.3, 4.3, 21],
22: [6.0, 5.6, 9.0, 22],
23: [8.75, 5.6, 6.6, 23]
I have tried this
items_dic = data[["Length","Width","Height","Pid" ]].set_index('Pid').T.to_dict('list')
items_dic = 20: [4.6, 4.3, 4.3],
21: [4.6, 4.3, 4.3],
22: [6.0, 5.6, 9.0],
23: [8.75, 5.6, 6.6]
but this does not include Pid in the list of values
Can someone explain why ?
python python-3.x pandas dictionary
edited Mar 12 at 6:26
jezrael
347k25304379
asked Mar 12 at 6:16
Rahul SharmaRahul Sharma
1638
New contributor
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have a dataframe and i want it to select a few columns and convert it into Dictionary in the a certain manner
Dataframe:
and here's the output I want
20: [4.6, 4.3, 4.3, 20],
21: [4.6, 4.3, 4.3, 21],
22: [6.0, 5.6, 9.0, 22],
23: [8.75, 5.6, 6.6, 23]
I have tried this
items_dic = data[["Length","Width","Height","Pid" ]].set_index('Pid').T.to_dict('list')
items_dic = 20: [4.6, 4.3, 4.3],
21: [4.6, 4.3, 4.3],
22: [6.0, 5.6, 9.0],
23: [8.75, 5.6, 6.6]
but this does not include Pid in the list of values
Can someone explain why ?
python python-3.x pandas dictionary
python python-3.x pandas dictionary
edited Mar 12 at 6:26
jezrael
347k25304379
asked Mar 12 at 6:16
Rahul SharmaRahul Sharma
1638
New contributor
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 12 at 6:26
jezrael
347k25304379
asked Mar 12 at 6:16
Rahul SharmaRahul Sharma
1638
New contributor
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited Mar 12 at 6:26
jezrael
347k25304379
edited Mar 12 at 6:26
jezrael
347k25304379
edited Mar 12 at 6:26
jezrael
347k25304379
347k25304379
asked Mar 12 at 6:16
Rahul SharmaRahul Sharma
1638
New contributor
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked Mar 12 at 6:16
Rahul SharmaRahul Sharma
1638
asked Mar 12 at 6:16
Rahul SharmaRahul Sharma
1638
1638
New contributor
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Rahul Sharma is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1
Please, write the dataframe in proper format, not in picture.
– pistol2myhead
Mar 12 at 6:19
1
I am sorry but I am fairly new to SO and I don't know how to do that
– Rahul Sharma
Mar 12 at 6:22
2
drop=Falseinset_indexis what you need
– Sreeram TP
Mar 12 at 6:25
add a comment |
1
Please, write the dataframe in proper format, not in picture.
– pistol2myhead
Mar 12 at 6:19
1
I am sorry but I am fairly new to SO and I don't know how to do that
– Rahul Sharma
Mar 12 at 6:22
2
drop=Falseinset_indexis what you need
– Sreeram TP
Mar 12 at 6:25
1
1
Please, write the dataframe in proper format, not in picture.
– pistol2myhead
Mar 12 at 6:19
Please, write the dataframe in proper format, not in picture.
– pistol2myhead
Mar 12 at 6:19
1
1
I am sorry but I am fairly new to SO and I don't know how to do that
– Rahul Sharma
Mar 12 at 6:22
I am sorry but I am fairly new to SO and I don't know how to do that
– Rahul Sharma
Mar 12 at 6:22
2
2
drop=False in set_index is what you need– Sreeram TP
Mar 12 at 6:25
drop=False in set_index is what you need– Sreeram TP
Mar 12 at 6:25
add a comment |
2 Answers
2
active
oldest
votes
Set parameter drop=False in DataFrame.set_index, because default parameter drop=False move column to index:
cols = ["Length","Width","Height","Pid"]
items_dic = data[cols].set_index('Pid', drop=False).T.to_dict('list')
print (items_dic)
20: [4.6, 4.3, 4.3, 20.0],
21: [4.6, 4.3, 4.3, 21.0],
22: [6.0, 5.6, 9.0, 22.0],
23: [8.75, 5.6, 6.6, 23.0]
answered Mar 12 at 6:19
jezraeljezrael
347k25304379
add a comment |
Or use dict(zip(...)):
>>> cols = ["Length","Width","Height","Pid"]
>>> items_dic = dict(zip(df['Pid'],df[cols].values.tolist()))
>>> items_dic
20: [4.8, 4.3, 4.3, 20.0], 21: [4.8, 4.3, 4.3, 21.0], 22: [6.0, 5.6, 9.0, 22.0], 23: [8.75, 5.6, 6.6, 23.0], 24: [6.0, 5.16, 6.6, 24.0]
>>>
edited Mar 12 at 7:45
Mudits
6681928
answered Mar 12 at 6:23
U9-ForwardU9-Forward
16.6k51543
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
);
);
Rahul Sharma is a new contributor. Be nice, and check out our Code of Conduct.
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%2f55115214%2fconvert-dataframe-into-dictionary%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Set parameter drop=False in DataFrame.set_index, because default parameter drop=False move column to index:
cols = ["Length","Width","Height","Pid"]
items_dic = data[cols].set_index('Pid', drop=False).T.to_dict('list')
print (items_dic)
20: [4.6, 4.3, 4.3, 20.0],
21: [4.6, 4.3, 4.3, 21.0],
22: [6.0, 5.6, 9.0, 22.0],
23: [8.75, 5.6, 6.6, 23.0]
answered Mar 12 at 6:19
jezraeljezrael
347k25304379
add a comment |
Set parameter drop=False in DataFrame.set_index, because default parameter drop=False move column to index:
cols = ["Length","Width","Height","Pid"]
items_dic = data[cols].set_index('Pid', drop=False).T.to_dict('list')
print (items_dic)
20: [4.6, 4.3, 4.3, 20.0],
21: [4.6, 4.3, 4.3, 21.0],
22: [6.0, 5.6, 9.0, 22.0],
23: [8.75, 5.6, 6.6, 23.0]
answered Mar 12 at 6:19
jezraeljezrael
347k25304379
add a comment |
Set parameter drop=False in DataFrame.set_index, because default parameter drop=False move column to index:
cols = ["Length","Width","Height","Pid"]
items_dic = data[cols].set_index('Pid', drop=False).T.to_dict('list')
print (items_dic)
20: [4.6, 4.3, 4.3, 20.0],
21: [4.6, 4.3, 4.3, 21.0],
22: [6.0, 5.6, 9.0, 22.0],
23: [8.75, 5.6, 6.6, 23.0]
answered Mar 12 at 6:19
jezraeljezrael
347k25304379
Set parameter drop=False in DataFrame.set_index, because default parameter drop=False move column to index:
cols = ["Length","Width","Height","Pid"]
items_dic = data[cols].set_index('Pid', drop=False).T.to_dict('list')
print (items_dic)
20: [4.6, 4.3, 4.3, 20.0],
21: [4.6, 4.3, 4.3, 21.0],
22: [6.0, 5.6, 9.0, 22.0],
23: [8.75, 5.6, 6.6, 23.0]
answered Mar 12 at 6:19
jezraeljezrael
347k25304379
edited Mar 12 at 6:26
answered Mar 12 at 6:19
jezraeljezrael
347k25304379
answered Mar 12 at 6:19
jezraeljezrael
347k25304379
answered Mar 12 at 6:19
jezraeljezrael
347k25304379
347k25304379
add a comment |
add a comment |
Or use dict(zip(...)):
>>> cols = ["Length","Width","Height","Pid"]
>>> items_dic = dict(zip(df['Pid'],df[cols].values.tolist()))
>>> items_dic
20: [4.8, 4.3, 4.3, 20.0], 21: [4.8, 4.3, 4.3, 21.0], 22: [6.0, 5.6, 9.0, 22.0], 23: [8.75, 5.6, 6.6, 23.0], 24: [6.0, 5.16, 6.6, 24.0]
>>>
edited Mar 12 at 7:45
Mudits
6681928
answered Mar 12 at 6:23
U9-ForwardU9-Forward
16.6k51543
add a comment |
Or use dict(zip(...)):
>>> cols = ["Length","Width","Height","Pid"]
>>> items_dic = dict(zip(df['Pid'],df[cols].values.tolist()))
>>> items_dic
20: [4.8, 4.3, 4.3, 20.0], 21: [4.8, 4.3, 4.3, 21.0], 22: [6.0, 5.6, 9.0, 22.0], 23: [8.75, 5.6, 6.6, 23.0], 24: [6.0, 5.16, 6.6, 24.0]
>>>
edited Mar 12 at 7:45
Mudits
6681928
answered Mar 12 at 6:23
U9-ForwardU9-Forward
16.6k51543
add a comment |
Or use dict(zip(...)):
>>> cols = ["Length","Width","Height","Pid"]
>>> items_dic = dict(zip(df['Pid'],df[cols].values.tolist()))
>>> items_dic
20: [4.8, 4.3, 4.3, 20.0], 21: [4.8, 4.3, 4.3, 21.0], 22: [6.0, 5.6, 9.0, 22.0], 23: [8.75, 5.6, 6.6, 23.0], 24: [6.0, 5.16, 6.6, 24.0]
>>>
edited Mar 12 at 7:45
Mudits
6681928
answered Mar 12 at 6:23
U9-ForwardU9-Forward
16.6k51543
Or use dict(zip(...)):
>>> cols = ["Length","Width","Height","Pid"]
>>> items_dic = dict(zip(df['Pid'],df[cols].values.tolist()))
>>> items_dic
20: [4.8, 4.3, 4.3, 20.0], 21: [4.8, 4.3, 4.3, 21.0], 22: [6.0, 5.6, 9.0, 22.0], 23: [8.75, 5.6, 6.6, 23.0], 24: [6.0, 5.16, 6.6, 24.0]
>>>
edited Mar 12 at 7:45
Mudits
6681928
answered Mar 12 at 6:23
U9-ForwardU9-Forward
16.6k51543
edited Mar 12 at 7:45
Mudits
6681928
edited Mar 12 at 7:45
Mudits
6681928
edited Mar 12 at 7:45
Mudits
6681928
6681928
answered Mar 12 at 6:23
U9-ForwardU9-Forward
16.6k51543
answered Mar 12 at 6:23
U9-ForwardU9-Forward
16.6k51543
answered Mar 12 at 6:23
U9-ForwardU9-Forward
16.6k51543
16.6k51543
add a comment |
add a comment |
Rahul Sharma is a new contributor. Be nice, and check out our Code of Conduct.
Rahul Sharma is a new contributor. Be nice, and check out our Code of Conduct.
Rahul Sharma is a new contributor. Be nice, and check out our Code of Conduct.
Rahul Sharma is a new contributor. Be nice, and check out our Code of Conduct.
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%2f55115214%2fconvert-dataframe-into-dictionary%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
1
Please, write the dataframe in proper format, not in picture.
– pistol2myhead
Mar 12 at 6:19
1
I am sorry but I am fairly new to SO and I don't know how to do that
– Rahul Sharma
Mar 12 at 6:22
2
drop=Falseinset_indexis what you need– Sreeram TP
Mar 12 at 6:25