Pandas: Create missing combination rows with zero values

by

Use pivot , then stack 

df.pivot(*df.columns).fillna(0).stack().to_frame('values').reset_index()
Out[564]: 
   col1 col2  values
0     1    A     2.0
1     1    B     4.0
2     1    C     0.0
3     2    A     6.0
4     2    B     8.0
5     2    C    10.0

More Related Contents:

  1. Comparing two dataframes and getting the differences [duplicate]
  2. Pandas: How to easily share a sample dataframe using df.to_dict()?
  3. Pandas: Get Dummies
  4. Get the name of a pandas DataFrame
  5. Calculate weighted average using a pandas/dataframe
  6. Comparing previous row values in Pandas DataFrame
  7. What is the difference between join and merge in Pandas?
  8. Ambiguity in Pandas Dataframe / Numpy Array “axis” definition
  9. Counting unique values in a column in pandas dataframe like in Qlik?
  10. Pandas SettingWithCopyWarning [duplicate]
  11. flattening nested Json in pandas data frame
  12. subsetting a Python DataFrame
  13. How can I count the number of consecutive TRUEs in a DataFrame?
  14. Max and Min date in pandas groupby
  15. Pandas data precision [duplicate]
  16. Pandas rolling apply using multiple columns
  17. pd.read_html() imports a list rather than a dataframe
  18. pandas bar plot combined with line plot shows the time axis beginning at 1970
  19. how to test if a variable is pd.NaT?
  20. How to change the plot order of the categorical x-axis
  21. Plotting histograms from grouped data in a pandas DataFrame
  22. making matplotlib scatter plots from dataframes in Python’s pandas
  23. Pandas pivot warning about repeated entries on index
  24. Convert a pandas groupby object to list of dataframes
  25. How to annotate grouped bar plot with percent by hue/legend group
  26. Set value on an entire column of a pandas dataframe
  27. seaborn heatmap using pandas dataframe
  28. Sorted bar charts with pandas/matplotlib or seaborn
  29. UnicodeDecodeError when reading CSV file in Pandas
  30. how to understand closed and label arguments in pandas resample method?

Leave a Comment