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

Probíhá Zveřejněno před 6 lety K zaplacení v momentě doručení
Probíhá

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 Zpracování dat

Identifikační číslo projektu: #15998003

O projektu

8 nabídek Projekt na dálku Aktivní před 6 lety

8 Freelnceři na váš projekt zveřejňují nabídky v průměru €9/hod.

usmanhassan123

I am MSc computer engineering and MPhil in STATISTICS

€11 EUR / hodina
(5 Recenzí)
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 Další

€11 EUR / hodina
(11 Recenzí)
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 / hodina
(9 Recenzí)
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 / hodina
(0 Recenzí)
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 Další

€10 EUR / hodina
(0 Recenzí)
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 Další

€6 EUR / hodina
(0 Recenzí)
0.0
datawen

A proposal has not yet been provided

€8 EUR / hodina
(0 Recenzí)
0.0