Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Transform Dic to dataframe
#3
(Apr-13-2022, 06:26 PM)deanhystad Wrote:
df =  pd.DataFrame({"XY": [15.2,22,22], "XX": [19, 23,23], "XXX": [17.8,24,24]})
print(df)
Output:
XY XX XXX 0 15.2 19 17.8 1 22.0 23 24.0 2 22.0 23 24.0
I don't understand your data. Maybe it should be like this:
foods = {  # Do not use "list" as a variable name.  "list" is the name of a built-in function.
    "Fruit":{"XY": [15.2,22,22], "XX": [19, 23,23], "XXX": [17.8,24,24]}
}
df =  pd.DataFrame(foods)
print(df)
Output:
Fruit XX [19, 23, 23] XXX [17.8, 24, 24] XY [15.2, 22, 22]

Many thanks for reply but now i am getting this kind of error

If using all scalar values, you must pass an index
Reply


Messages In This Thread
Transform Dic to dataframe - by d9d9d - Apr-13-2022, 06:02 PM
RE: Transform Dic to dataframe - by deanhystad - Apr-13-2022, 06:26 PM
RE: Transform Dic to dataframe - by d9d9d - Apr-13-2022, 06:45 PM
RE: Transform Dic to dataframe - by Larz60+ - Apr-14-2022, 09:11 AM
RE: Transform Dic to dataframe - by perfringo - Apr-14-2022, 09:35 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Transform 3 Columns into Single Column DaveG 9 3,484 Mar-19-2025, 03:46 AM
Last Post: robbert23
  Transform a pdf to markdown zzied 0 327 Feb-11-2025, 10:22 AM
Last Post: zzied
  [SOLVED] Looking for documentation on Reportlab's canvas.transform() function NeilUK 1 1,435 Aug-23-2023, 01:21 PM
Last Post: NeilUK
  How to transform from wide to long format in python shantanu97 1 2,347 Nov-21-2021, 11:53 AM
Last Post: buran
  Transform list or set regardless of nesting structure blubb 2 2,664 Mar-10-2020, 07:17 PM
Last Post: ibreeden
  Transform simplified dictionary to nested dictionaries bhojendra 1 2,967 Jul-02-2019, 02:05 PM
Last Post: ichabod801
  transform list to tuple with takaa 2 3,521 Nov-28-2017, 10:44 PM
Last Post: takaa
  Laplace Inverse Transform Implementation jafar1363 11 17,708 Nov-17-2016, 08:52 PM
Last Post: nilamo

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020