We take a horizontal cylinder of length $L$ and fill it with incompressible water of mass $m$ and close the two ends with lids. If we start rotating the cylinder with respect to one of the ends,the other end will feel a force due to the centrifugal force. Since water is a continuous body,we can assume it to be concentrated at the center of mass,then centrifugal force on COM will be $\frac{Mw^2}{2L}$. But it seems to me a shortcut way of explaining why this much force is being applied on the wall or other end. How do we derive that this much force is applied on the other end by integrating along the whole mass(which is a more general and intuitive way to guess what's going on).
Also,the fact that the other end feels a force due to centrifugal force is only valid from the frame of reference of the cylinder. How will someone from the ground frame explain this phenomenon? What force will he account for causing the pressure on that end?