Python Pandas: Convert “.value_counts” output to dataframe

by

Use rename_axis for name of column from index and reset_index:

df = df.value_counts().rename_axis('unique_values').reset_index(name="counts")
print (df)
   unique_values  counts
0              2       3
1              1       2

Or if need one column DataFrame use Series.to_frame:

df = df.value_counts().rename_axis('unique_values').to_frame('counts')
print (df)
               counts
unique_values        
2                   3
1                   2

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Filter pandas DataFrame by substring criteria
  3. Binning a column with Python Pandas
  4. Aggregation in Pandas
  5. Compare two DataFrames and output their differences side-by-side
  6. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  7. Can pandas automatically read dates from a CSV file?
  8. Selecting a row of pandas series/dataframe by integer index
  9. pandas dataframe str.contains() AND operation
  10. How do I find the closest values in a Pandas series to an input number?
  11. How do I count the NaN values in a column in pandas DataFrame?
  12. getting the index of a row in a pandas apply function
  13. How to flatten a pandas dataframe with some columns as json?
  14. Tilde sign in pandas DataFrame
  15. Drop columns whose name contains a specific string from pandas DataFrame
  16. Find the unique values in a column and then sort them
  17. how do I calculate a rolling idxmax
  18. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  19. Pandas won’t fillna() inplace
  20. python Pandas DataFrame copy(deep=False) vs copy(deep=True) vs ‘=’
  21. From password-protected Excel file to pandas DataFrame
  22. How can repetitive rows of data be collected in a single row in pandas?
  23. How is pandas groupby method actually working?
  24. FastAPI is very slow in returning a large amount of JSON data
  25. Dynamically filtering a pandas dataframe
  26. Remove substring from column based on another column
  27. Remove ends of string entries in pandas DataFrame column
  28. How to convert DataFrame.append() to pandas.concat()?
  29. Pythonic/efficient way to strip whitespace from every Pandas Data frame cell that has a stringlike object in it
  30. Difference between df[x], df[[x]], df[‘x’] , df[[‘x’]] and df.x

Leave a Comment