How to group columns by label in a histogram using a panda DataFrame?
Marisa
I have a panda dataframe called language consisting of two columns:
lang level
0 english 2
1 spanish 2
2 spanish 1
3 english 1
4 english 3
5 spanish 2
6 spanish 1
7 spanish 3
I would like to represent it in a histogram group by the categorical value language in such a way that in the same plot I have 2 groups -one for each language- with as many bar as many labels I have in the level column (3 in this case).
So far I have tried the following by previously categorizaing lang getting a label of 1 to english and of 2 to spanish:
language.hist(by=language['lang'])
With what I obtained the following graph which is not what I want.
Ideally I would like a graph similar to this where the LetterGrade would be language and the legend would refer to the level variable.
BENY
Using :
pd.crosstab(df.lang,df.level).plot(kind='bar')
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: OData Exception Failed to execute OData Metadata request
- Next: Radio button inside tabpanel appears at the bottom
Related
Related Related
- 1
Creating a new column in panda dataframe using logical indexing and group by
- 2
how to add columns label on a Pandas DataFrame
- 3
How to filter pandas dataframe columns by partial label
- 4
mean of all the columns of a panda dataframe?
- 5
Converting list in panda dataframe into columns
- 6
How to Read Text file as input and write into excel columns using panda?
- 7
dataframe.plot histogram change label
- 8
How to group a column in a csv file by a range and plot histogram using python?
- 9
How to flatten Nested Excel data using Panda or Spark Dataframe?
- 10
How to flatten Nested Excel data using Panda or Spark Dataframe?
- 11
How to slice/chop a string using multiple indexes in a panda DataFrame
- 12
Pandas - How to group sub columns of a dataframe?
- 13
How to choose a group of columns in a Dask Dataframe?
- 14
Using Crossfilter to Filter and Group for Histogram
- 15
Group over Series of lists in Panda Dataframe
- 16
Python: logical comparing with columns in panda's dataframe
- 17
tPlotting scatter_matrix with selected columns from panda dataframe using scatter_matrix(dataset)
- 18
How to Label encode multiple non-contiguous dataframe columns
- 19
Plotting histogram using seaborn for a dataframe
- 20
Setting axis label and histogram labels using GNUplot
- 21
How to explode the column value without duplicating the other columns values in panda dataframe?
- 22
Histogram of a label
- 23
How to label data index with count using 3D histogram in Matlab
- 24
how to group by multiple columns using linq
- 25
How to group values of columns using PHP MySQL?
- 26
how to group by multiple columns using linq
- 27
How to group values of columns using PHP MySQL?
- 28
using Python, How to group a column in Dataframe by the hour?
- 29
How to group a DataFrame using labels and sum them?
Comments