不知道题目描述的是否准确，问题是这样的：以下的部分数据中，implementing_agency 数据是字符型，usd_current 是数值型，implenmenting_agency中有不同的公司类型（国企和私企）。我想计算implementing_agency中国企和私企的usd_current在总usd_current中各自占的比例。但是因为implementing_agency是字符的，所以不知道怎么处理，求高手赐教，谢谢！


usd_current    implementing_agency
14                 China Road & Bridge Corporation (CRBC), State-Owned Company
1200              CITIC Group Corporation, State-Owned Company
.3525             Zhongxing Technologies (ZTE), State-Owned Company
1                   Hunan Construction Engineering Group Corporation of China, State-Owned Company
1.65               Weihai International Economic & Technical Cooperative Co., Ltd (WIETC), Private Sector
.49                 China Road & Bridge Corporation (CRBC), State-Owned Company
2                    China Railway Construction Corporation (CRCC), State-Owned Company
5.79               Weihai International Economic & Technical Cooperative Co., Ltd (WIETC), Private Sector
27.7               Sinohydro Corporation, State-Owned Company
........             ...................................