Create a new dataset from existing sources-easy data cleaning! (STATA and Excel proficiency is required)

进行中 已发布的 6 年前 货到付款
进行中

This task consists in creating a dataset containing information on balance sheets of Colombian mining firms. The data can be downloaded from the following website:

[url removed, login to view]

I would like to have a unique dataset containing information on "Estados Finacieros" (Balance General BG, Estado Resultados ER and Flujo Efectivo) from year 1995 to year 2015.

Note that:

1-Variables names should be armonized year by year because they slightly change.

2-Mining Firms can be selected using the file "sector list for sirem". Note that the CIIU code has changed in the last years, so you will use both CIIU 3.1. and CIIU 4 according to the year of the survey.

The second step of the task consists in merging the SIREM-mining dataset you have created with the TITULOS2014 dataset. You should merge according to the firm ID number or firm name. It would be great if you could check online the name of the owner of the firms that are not matched and try the merge with the owner name (in TITULOS 2014 file you will see that there are many "person" names rather than firms name). The merge won't be perfect, but I would like to obtain as many matches as possible.

The final output should be the following:

-stata file containing estados financieros info of mining firms in sirem

-same dataset but in excel format

-stata file merged to TITULOS2014

-same file but in excel

Data Cleansing Data Extraction 数据处理

项目ID: #15998003

关于项目

8个方案 远程项目 活跃的6 年前

有8名威客正在参与此工作的竞标,均价€9/小时

usmanhassan123

I am MSc computer engineering and MPhil in STATISTICS

€11 EUR / 小时
(5条评论)
4.1
charleslimnet

I possess exceptional statistical analysis experience. I am fully skilled in both qualitative and quantitative analytical research methods. I have experience in analyzing Statistical data using Excel, STATA, R-Programm 更多

€11 EUR / 小时
(11条评论)
4.1
awaisjahangir25

Hi, I can work on your project. Kindly text me for further detail. You can review my profile to know more about my skills and experience required for this work. Regards Awaisjehangir

€8 EUR / 小时
(9条评论)
3.3
marwakoka

my experience is 10 years in admin work, data entry and internet surfing making hotel's brochures i am also graduated from faculty of language my English is excellent, Spanish and French

€10 EUR / 小时
(0条评论)
0.0
saifullah69

Hello Sir, Thank yours very much for your job posting. I have got your job posting on “Data Entry”. Through your job description, I have come to know that you need a professional data entry expert. You have mentione 更多

€10 EUR / 小时
(0条评论)
0.0
tamamallick

Dear Sir I have long experience on this field. I'm able to complete this work with your satisfaction. I'm Computer Engineer. So I varst knowledge about file format and related work. Thank you so much for your consid 更多

€6 EUR / 小时
(0条评论)
0.0
datawen

A proposal has not yet been provided

€8 EUR / 小时
(0条评论)
0.0