US cable operator Charter Communications has agreed to buy competitor Time Warner Cable in a deal worth $78.7bn (£52bn).