Create new dataframe from old dataframe

[arvin]

I have a pandas dataframe that has 2 columns


,And I want to create a new dataframe with column names: lowest, highest, count, and amount. The lowest and highest columns represent the range. The count column represents the number of values coming in the particular range, and the amount column represents the total of the values in the particular range.


And is it possible that we save that dataframe as an Excel file, and we can change the lowest and highest values in excel files according to our needs, while other values automatically get calculated.