{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[],"authorship_tag":"ABX9TyMKAg85I9vSsrAzmU9Z591D"},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","execution_count":null,"metadata":{"id":"ibMf0OM5auGe"},"outputs":[],"source":["import pandas as pd\n","import seaborn as sns\n","import re"]},{"cell_type":"code","source":["# leyendo archivo\n","df = pd.read_csv('Limpieza.csv')"],"metadata":{"id":"62NeYpcJbMPU"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["df"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":687},"id":"ojrtG9c7bTZg","executionInfo":{"status":"ok","timestamp":1726802117018,"user_tz":180,"elapsed":695,"user":{"displayName":"Horacio Laphitz","userId":"05970776226255252387"}},"outputId":"3c5be84b-5e18-46af-c87d-51144067f3e4"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":[" Id?empleado Name Apellido birth_date género \\\n","0 00-0037846 Kimmy Walczynski 06/04/1991 hombre \n","1 00-0041533 Ignatius Springett 6/29/1984 hombre \n","2 00-0045747 Corbie Bittlestone 7/29/1989 hombre \n","3 00-0055274 Baxy Matton 9/14/1982 mujer \n","4 00-0076100 Terrell Suff 04/11/1994 mujer \n","... ... ... ... ... ... \n","22218 00-0076100 Terrell Suff 04/11/1994 mujer \n","22219 00-0116166 Kacie Offiler 1/18/1971 hombre \n","22220 00-0363185 Sandro Admans 11/19/1979 hombre \n","22221 00-0380704 Eugene Lehrahan 10/14/1988 mujer \n","22222 00-0381660 Wainwright Corfield 12/13/1996 hombre \n","\n"," area salary star_date finish_date \\\n","0 Engineering $77,719 1/20/2002 NaN \n","1 Business Development $135,189 04/08/2019 NaN \n","2 Sales $122,484 10/12/2010 NaN \n","3 Services $82,100 04/10/2005 NaN \n","4 Product Management $114,648 9/29/2010 2029-10-29 06:09:38 UTC \n","... ... ... ... ... \n","22218 Product Management $114,648 9/29/2010 2029-10-29 06:09:38 UTC \n","22219 Engineering $121,044 09/01/2018 NaN \n","22220 Product Management $174,195 11/08/2012 NaN \n","22221 Engineering $66,031 6/27/2007 NaN \n","22222 Engineering $164,055 2/20/2001 2008-12-05 01:21:48 UTC \n","\n"," promotion_date type \n","0 NaN 0 \n","1 NaN 0 \n","2 NaN 1 \n","3 NaN 0 \n","4 NaN 1 \n","... ... ... \n","22218 NaN 1 \n","22219 NaN 0 \n","22220 NaN 1 \n","22221 NaN 1 \n","22222 NaN 0 \n","\n","[22223 rows x 11 columns]"],"text/html":["\n","
\n","
\n","\n","\n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n"," \n","
Id?empleadoNameApellidobirth_dategéneroareasalarystar_datefinish_datepromotion_datetype
000-0037846KimmyWalczynski06/04/1991hombreEngineering$77,7191/20/2002NaNNaN0
100-0041533IgnatiusSpringett6/29/1984hombreBusiness Development$135,18904/08/2019NaNNaN0
200-0045747CorbieBittlestone7/29/1989hombreSales$122,48410/12/2010NaNNaN1
300-0055274BaxyMatton9/14/1982mujerServices$82,10004/10/2005NaNNaN0
400-0076100TerrellSuff04/11/1994mujerProduct Management$114,6489/29/20102029-10-29 06:09:38 UTCNaN1
....................................
2221800-0076100TerrellSuff04/11/1994mujerProduct Management$114,6489/29/20102029-10-29 06:09:38 UTCNaN1
2221900-0116166KacieOffiler1/18/1971hombreEngineering$121,04409/01/2018NaNNaN0
2222000-0363185SandroAdmans11/19/1979hombreProduct Management$174,19511/08/2012NaNNaN1
2222100-0380704EugeneLehrahan10/14/1988mujerEngineering$66,0316/27/2007NaNNaN1
2222200-0381660WainwrightCorfield12/13/1996hombreEngineering$164,0552/20/20012008-12-05 01:21:48 UTCNaN0
\n","

22223 rows × 11 columns

\n","
\n","
\n","\n","
\n"," \n","\n"," \n","\n"," \n","
\n","\n","\n","
\n"," \n","\n","\n","\n"," \n","
\n","\n","
\n"," \n"," \n"," \n","
\n","\n","
\n","
\n"],"application/vnd.google.colaboratory.intrinsic+json":{"type":"dataframe","variable_name":"df","summary":"{\n \"name\": \"df\",\n \"rows\": 22223,\n \"fields\": [\n {\n \"column\": \"Id?empleado\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 22214,\n \"samples\": [\n \"75-3688247\",\n \"35-2768611\",\n \"67-4050288\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Name\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 7761,\n \"samples\": [\n \"Mariette\",\n \"Chuck\",\n \"Moyra\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Apellido\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 17755,\n \"samples\": [\n \"Pilger\",\n \"Mahood\",\n \"Pietsma\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"birth_date\",\n \"properties\": {\n \"dtype\": \"object\",\n \"num_unique_values\": 10854,\n \"samples\": [\n \"8/18/1969\",\n \"12/21/1993\",\n \"9/27/1972\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"g\\u00e9nero\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 2,\n \"samples\": [\n \"mujer\",\n \"hombre\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"area\",\n \"properties\": {\n \"dtype\": \"category\",\n \"num_unique_values\": 13,\n \"samples\": [\n \"Research and Development\",\n \"Training\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"salary\",\n \"properties\": {\n \"dtype\": \"string\",\n \"num_unique_values\": 20296,\n \"samples\": [\n \" $168,403 \",\n \" $76,726 \"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"star_date\",\n \"properties\": {\n \"dtype\": \"object\",\n \"num_unique_values\": 7016,\n \"samples\": [\n \"10/21/2010\",\n \"08/01/2016\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"finish_date\",\n \"properties\": {\n \"dtype\": \"date\",\n \"min\": \"2001-04-15 02:05:19+00:00\",\n \"max\": \"2041-10-29 03:48:59+00:00\",\n \"num_unique_values\": 3929,\n \"samples\": [\n \"2024-01-08 20:51:31 UTC\",\n \"2017-12-27 16:32:23 UTC\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"promotion_date\",\n \"properties\": {\n \"dtype\": \"date\",\n \"min\": \"2018-08-02 00:00:00\",\n \"max\": \"2023-04-26 00:00:00\",\n \"num_unique_values\": 20,\n \"samples\": [\n \"August 29, 2022\",\n \"June 4, 2022\"\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"type\",\n \"properties\": {\n \"dtype\": \"number\",\n \"std\": 0,\n \"min\": 0,\n \"max\": 1,\n \"num_unique_values\": 2,\n \"samples\": [\n 1,\n 0\n ],\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}"}},"metadata":{},"execution_count":3}]},{"cell_type":"code","source":[],"metadata":{"id":"95Aq_bWTb3Qy"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["def capitalize_english(name):\n"," return re.sub(\n"," r\"(\\w)(\\w*)\", lambda m: m.group(1).upper() + m.group(2).lower(), name\n"," )\n","\n"],"metadata":{"id":"tUf7AL7ObqXc"},"execution_count":null,"outputs":[]}]}