Proiect final in limbajele Python si SAS
Profesor coordonator: Uta Adina
An universitar: 2019-2020
Grupa 1078 | Seria C
Acesta este proiectul final pentru cursul universitar "Pachete Software" din anul III, semestrul II. ~ Analiza activitatii unei organizatii si a eventualelor posibilitati de extindere a acesteia ~ In cazul proiectului meu, acesta se refera la o telefiziune coreeana, Arirang TV, al carei Manager doreste extinderea si diversificarea activitatii acesteia.
Proiectul contine 4 parti:
- Partea I - Excel
- Partea a II-a - Python
- Partea a III-a - Programare SAS
- Partea a IV-a - SAS Enterprise Guide
![Excel Excel](https://github.com/Adriana-Giol/Adriana-Giol/raw/main/Logo/Logo_Tools_Excel.png)
![Python Python](https://github.com/Adriana-Giol/Adriana-Giol/raw/main/Logo/Logo_Tools_Python.png)
![Anaconda Anaconda](https://github.com/Adriana-Giol/Adriana-Giol/raw/main/Logo/Logo_Tools_Anaconda.png)
![SAS SAS](https://github.com/Adriana-Giol/Adriana-Giol/raw/main/Logo/Logo_Tools_SAS.png)
![Jupyter Lab Jupyter Lab](https://github.com/Adriana-Giol/Adriana-Giol/raw/main/Logo/Logo_Tools_JupyterLab.png)
![Excel Excel](https://private-user-images.githubusercontent.com/60271540/242269100-af475801-fcd1-419b-a5a6-f2c6a5b45e22.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ4NjE3ODEsIm5iZiI6MTcyNDg2MTQ4MSwicGF0aCI6Ii82MDI3MTU0MC8yNDIyNjkxMDAtYWY0NzU4MDEtZmNkMS00MTliLWE1YTYtZjJjNmE1YjQ1ZTIyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MjglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODI4VDE2MTEyMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTk2ODBjMmJkNTczZjNmMjRhMmE5ODAwZGZlYjc3ZmNhNGM0NjEwMjNjMmE0ODZmZDFlZWZmNDk5ZTc1MWIyNmQmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.h04nAvGNWmbjI5HJ7PwrWUxx_ZfsPevJvtPeiHrEByw)
![Python Python](https://private-user-images.githubusercontent.com/60271540/242270772-43189618-e00a-414d-866f-d78cda6f03e9.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ4NjE3ODEsIm5iZiI6MTcyNDg2MTQ4MSwicGF0aCI6Ii82MDI3MTU0MC8yNDIyNzA3NzItNDMxODk2MTgtZTAwYS00MTRkLTg2NmYtZDc4Y2RhNmYwM2U5LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MjglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODI4VDE2MTEyMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTkwYjcyZWQyMzlkNjFiNDJkYzlmYjE0YWY0MzM4YjUxMjlhNTUwM2NlNmQ4NTNkOWVhZjE5YzllOGExYzMwZDYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.r8vanikSNyKDumC6ZP0dJaBMGpLUMo3xhrTRTXPWgCU)
![Programare SAS Programare SAS](https://private-user-images.githubusercontent.com/60271540/242270855-54a9df0e-c79d-4d73-bad6-dc949d49c45b.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ4NjE3ODEsIm5iZiI6MTcyNDg2MTQ4MSwicGF0aCI6Ii82MDI3MTU0MC8yNDIyNzA4NTUtNTRhOWRmMGUtYzc5ZC00ZDczLWJhZDYtZGM5NDlkNDljNDViLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MjglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODI4VDE2MTEyMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWE3OThhZjAxYTVjNjgzNzMyMWFhMGY3MTg0N2RmYWU4YWU2NTYzZWVlMDRjMDM0ZmM3N2FmNjBlYjkxZTZhODkmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.msvJlgXavjZW5Tiqxh6nW80B9cZKMff2s2jANAixO0g)
![SAS Enterprise SAS Enterprise](https://private-user-images.githubusercontent.com/60271540/242270950-6f3cbf0a-3d44-4ae5-b738-d034b282d867.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjQ4NjE3ODEsIm5iZiI6MTcyNDg2MTQ4MSwicGF0aCI6Ii82MDI3MTU0MC8yNDIyNzA5NTAtNmYzY2JmMGEtM2Q0NC00YWU1LWI3MzgtZDAzNGIyODJkODY3LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNDA4MjglMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjQwODI4VDE2MTEyMVomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTkzMTQzZmExOTU3NGE5MDM0YmY4YjdkNDAwYjQ5ZjIyMTMwNTYxYzkwYjcxZGNhYTBkYjNkZmVmNjgwOTBiMTYmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0JmFjdG9yX2lkPTAma2V5X2lkPTAmcmVwb19pZD0wIn0.f5uCs2yRHK0E98deditcPHJocXIB_XL17HU48u_5NIU)
✔️1. Funcţii matriceale
✔️2. Funcţii financiare
✔️3. Funcţii logice
✔️4. Funcţii definite de utilizator
✔️5. Pivot Table
✔️6. Goalseek
✔️7. Scenarii
✔️8. Solver
✔️9. Subtotaluri
✔️10. Grafice
✔️1. Liste si dictionare
✔️2. Seturi si tupluri
✔️3. Definire si apelare de functii
✔️4. Structuri conditionale
✔️5. Structuri repetitive
✔️6. Import fisier CSV/JSON in pachetul pandas
✔️7. Accesarea datelor cu loc şi iloc
✔️8. Modificarea datelor în pachetul pandas
✔️9. Functii de grup
✔️10.Tratarea valorilor lipsă
✔️11.Stergerea de coloane şi înregistrări
✔️12.Prelucrări statistice, gruparea şi agregarea datalor în pachetul pandas
✔️13.Prelucrarea seturilor de date cu merge / join
✔️14.Reprezentare grafică a datelor cu pachetul matplotlib
✔️15.Utilizarea pachetului scikit-learn (clusterizare, regresie logistică)
✔️16.Utilizarea pachetului statmodels (regresie multiplă)
✔️1. Crearea unui set de date SAS din fișiere externe
✔️2. Crearea şi folosirea de formate definite de utilizator
✔️3. Procesarea iterativă şi condiţională a datelor
✔️4. Crearea de subseturi de date
✔️5. Utilizarea de funcţii SAS
✔️6. Combinarea seturilor de date prin proceduri specifice SAS şi SQL
✔️7. Utilizarea de masive
✔️8. Utilizarea de proceduri pentru raportare
✔️9. Folosirea de proceduri statistice
✔️10.Generarea de grafice
✔️1. Importul unui fisier non-SAS
✔️2. Interogări
✔️3. Joncţiune
✔️4. Folosirea parametrilor
✔️5. Rapoarte
✔️6. Grafice
✔️7. Prelucrări statistice
✔️8. Formate definite de utilizator
✔️9. Crearea unui document compus
✔️10.Stiluri create de utilizator