Bottom Page

Thread Rating:
  • 2 Vote(s) - 3.5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
 pd.DataFrame question
#1
I hope you are all having a good. Why does the following program cause Python to crash (I'm using the Jupyter notebook):

df2=pd.DataFrame(data=df,index=df['Day of Week'],columns=df['Hour'])

df is a DataFrame already and I want it to have an index of the day of the week variable and columns for the hour variable.
Quote
#2
You should check documentation for pandas dataframe. columns parameter accepts list of column names, so you are trying to create dataframe with colums named as values in df.Hour column (with width given by lenght of your original dataframe).

If you just want to use existing column as an index, just use:
df2 = df.set_index('Day of Week', drop=True)[['Hour']]
that will set index values from Day of Week column and deletes Day of Week column. If your original dataframe contains only Hour and Day of Week columns, selecting with [['Hour']] is obsolete.
smw10c and nilamo like this post
Quote
#3
(Mar-30-2017, 08:17 PM)zivoni Wrote: You should check documentation for pandas dataframe. columns parameter accepts list of column names, so you are trying to create dataframe with colums named as values in df.Hour column (with width given by lenght of your original dataframe). If you just want to use existing column as an index, just use:
 df2 = df.set_index('Day of Week', drop=True)[['Hour']] 
that will set index values from Day of Week column and deletes Day of Week column. If your original dataframe contains only Hour and Day of Week columns, selecting with [['Hour']] is obsolete.


Thank you!
nilamo likes this post
Quote

Top Page

Possibly Related Threads...
Thread Author Replies Views Last Post
  Python & Dataframe basic question georgialtr 0 271 Apr-06-2020, 03:59 PM
Last Post: georgialtr
  Simple pandas dataframe question popohoma 1 836 Jan-03-2019, 05:00 PM
Last Post: ashlardev
  Newbie question to return only the index of a dataframe zydjohn 0 890 Jan-22-2018, 03:40 PM
Last Post: zydjohn
  Question for dataframe to replace INF value zydjohn 0 3,471 Jan-15-2018, 10:00 PM
Last Post: zydjohn
  very simple dataframe question really_this_dumb 0 799 Jan-02-2018, 11:30 AM
Last Post: really_this_dumb
  Newbie question: how to generate dataframe and use multiple regression zydjohn 0 862 Dec-10-2017, 09:49 AM
Last Post: zydjohn

Forum Jump:


Users browsing this thread: 1 Guest(s)