how to get balance amount using sql

let suppose we have 2 customer and they are doing credit and debit transactions in his account. and we have to find, how balance amount in their account using spark sql or dataframe API.

C_id	Trans_type	amount
c_1	debit	200
c_1	credit	100
c_2	credit	500
c_2	debit	200
c_2	credit	500
c_1	credit	100
c_1	credit	100

C_id	balance
c_1	100
c_2	800