{"id":90906,"date":"2025-01-02T06:58:31","date_gmt":"2025-01-02T03:28:31","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/"},"modified":"2025-01-02T06:58:31","modified_gmt":"2025-01-02T03:28:31","slug":"guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/","title":{"rendered":"\u0631\u0627\u0647\u0646\u0645\u0627\u06cc \u062f\u0631\u06a9 \u0642\u0637\u0639\u06cc \u0641\u0631\u0622\u06cc\u0646\u062f ETL \u062f\u0631 \u0645\u0647\u0646\u062f\u0633\u06cc \u062f\u0627\u062f\u0647"},"content":{"rendered":"<div data-article-id=\"2185147\" id=\"article-body\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#Proceso_de_ETL_Extract_Transform_Load\" >Proceso de ETL (Extract, Transform, Load)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#1_%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC_%D8%B9%D8%B5%D8%A7%D8%B1%D9%87\" >1. \u0627\u0633\u062a\u062e\u0631\u0627\u062c (\u0639\u0635\u0627\u0631\u0647)<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#%D9%85%D8%AB%D8%A7%D9%84\" >\u0645\u062b\u0627\u0644:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#2_%D8%AF%DA%AF%D8%B1%DA%AF%D9%88%D9%86%DB%8C\" >2. \u062f\u06af\u0631\u06af\u0648\u0646\u06cc<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#%D9%85%D8%AB%D8%A7%D9%84-2\" >\u0645\u062b\u0627\u0644:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#3_%D8%A8%D8%A7%D8%B1%DA%AF%D8%B0%D8%A7%D8%B1%DB%8C_%DA%A9%D9%86%DB%8C%D8%AF\" >3. \u0628\u0627\u0631\u06af\u0630\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#%D9%85%D8%AB%D8%A7%D9%84-3\" >\u0645\u062b\u0627\u0644:<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#%D8%A7%D8%A8%D8%B2%D8%A7%D8%B1%D9%87%D8%A7%DB%8C_ETL\" >\u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc ETL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/guia-para-entender-definitivamente-un-proceso-etl-en-ingenieria-de-datos-26e2\/#%D9%86%D8%AA%DB%8C%D8%AC%D9%87_%DA%AF%DB%8C%D8%B1%DB%8C\" >\u0646\u062a\u06cc\u062c\u0647 \u06af\u06cc\u0631\u06cc<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"Proceso_de_ETL_Extract_Transform_Load\"><\/span>\n<p>  Proceso de ETL (Extract, Transform, Load)<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0641\u0631\u0622\u06cc\u0646\u062f ETL (Extract, Transform, Load) \u062f\u0631 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0633\u0627\u0633\u06cc \u0627\u0633\u062a \u0648 \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u0642\u0627\u0644 \u0648 \u062a\u0628\u062f\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u0645\u062a\u0639\u062f\u062f \u0628\u0647 \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0645\u0627\u0646\u0646\u062f \u0627\u0646\u0628\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0647\u0631 \u0645\u0631\u062d\u0644\u0647 \u0627\u0632 \u0641\u0631\u0622\u06cc\u0646\u062f ETL \u062f\u0631 \u0632\u06cc\u0631 \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_%D8%A7%D8%B3%D8%AA%D8%AE%D8%B1%D8%A7%D8%AC_%D8%B9%D8%B5%D8%A7%D8%B1%D9%87\"><\/span>\n<p>  1. \u0627\u0633\u062a\u062e\u0631\u0627\u062c (\u0639\u0635\u0627\u0631\u0647)<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0645\u0631\u062d\u0644\u0647 \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0634\u0627\u0645\u0644 \u0628\u0647 \u062f\u0633\u062a \u0622\u0648\u0631\u062f\u0646 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u0645\u062e\u062a\u0644\u0641 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a. \u0627\u06cc\u0646 \u0645\u0646\u0627\u0628\u0639 \u0645\u06cc \u062a\u0648\u0627\u0646\u0646\u062f \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u060c \u0641\u0627\u06cc\u0644 \u0647\u0627\u06cc \u0645\u0633\u0637\u062d\u060c API \u0647\u0627 \u0648 \u063a\u06cc\u0631\u0647 \u0628\u0627\u0634\u0646\u062f. \u0647\u062f\u0641 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u062a\u0645\u0627\u0645 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0644\u0627\u0632\u0645 \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0627\u0633\u062a.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D9%85%D8%AB%D8%A7%D9%84\"><\/span>\n<p>  \u0645\u062b\u0627\u0644:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"kn\">import<\/span> <span class=\"n\">pandas<\/span> <span class=\"k\">as<\/span> <span class=\"n\">pd<\/span>\n\n<span class=\"c1\"># Extracci\u00f3n de datos desde una base de datos SQL\n<\/span><span class=\"kn\">import<\/span> <span class=\"n\">sqlalchemy<\/span>\n<span class=\"n\">engine<\/span> <span class=\"o\">=<\/span> <span class=\"n\">sqlalchemy<\/span><span class=\"p\">.<\/span><span class=\"nf\">create_engine<\/span><span class=\"p\">(<\/span><span class=\"sh\">'<\/span><span class=\"s\">mysql+pymysql:\/\/user:password@host\/dbname<\/span><span class=\"sh\">'<\/span><span class=\"p\">)<\/span>\n<span class=\"n\">df<\/span> <span class=\"o\">=<\/span> <span class=\"n\">pd<\/span><span class=\"p\">.<\/span><span class=\"nf\">read_sql<\/span><span class=\"p\">(<\/span><span class=\"sh\">'<\/span><span class=\"s\">SELECT * FROM tabla_origen<\/span><span class=\"sh\">'<\/span><span class=\"p\">,<\/span> <span class=\"n\">engine<\/span><span class=\"p\">)<\/span>\n\n<span class=\"c1\"># Extracci\u00f3n de datos desde un archivo CSV\n<\/span><span class=\"n\">df_csv<\/span> <span class=\"o\">=<\/span> <span class=\"n\">pd<\/span><span class=\"p\">.<\/span><span class=\"nf\">read_csv<\/span><span class=\"p\">(<\/span><span class=\"sh\">'<\/span><span class=\"s\">ruta\/al\/archivo.csv<\/span><span class=\"sh\">'<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"2_%D8%AF%DA%AF%D8%B1%DA%AF%D9%88%D9%86%DB%8C\"><\/span>\n<p>  2. \u062f\u06af\u0631\u06af\u0648\u0646\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u062f\u0631 \u0645\u0631\u062d\u0644\u0647 \u062a\u0628\u062f\u06cc\u0644\u060c \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0634\u062f\u0647 \u062a\u0645\u06cc\u0632\u060c \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0648 \u062a\u0628\u062f\u06cc\u0644 \u0645\u06cc \u0634\u0648\u0646\u062f \u062a\u0627 \u0628\u0627 \u0641\u0631\u0645\u062a \u0645\u0648\u0631\u062f \u0646\u06cc\u0627\u0632 \u0633\u06cc\u0633\u062a\u0645 \u0647\u062f\u0641 \u0645\u0637\u0627\u0628\u0642\u062a \u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u0646\u062f. \u0627\u06cc\u0646 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0634\u0627\u0645\u0644 deduplication\u060c \u062a\u0628\u062f\u06cc\u0644 \u0646\u0648\u0639 \u062f\u0627\u062f\u0647\u060c \u0639\u0627\u062f\u06cc \u0633\u0627\u0632\u06cc\u060c \u062a\u062c\u0645\u06cc\u0639 \u0648 \u063a\u06cc\u0631\u0647 \u0628\u0627\u0634\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D9%85%D8%AB%D8%A7%D9%84-2\"><\/span>\n<p>  \u0645\u062b\u0627\u0644:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"c1\"># Limpieza de datos\n<\/span><span class=\"n\">df<\/span><span class=\"p\">.<\/span><span class=\"nf\">dropna<\/span><span class=\"p\">(<\/span><span class=\"n\">inplace<\/span><span class=\"o\">=<\/span><span class=\"bp\">True<\/span><span class=\"p\">)<\/span>  <span class=\"c1\"># Eliminar filas con valores nulos\n<\/span><span class=\"n\">df<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">columna<\/span><span class=\"sh\">'<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"n\">df<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">columna<\/span><span class=\"sh\">'<\/span><span class=\"p\">].<\/span><span class=\"nf\">astype<\/span><span class=\"p\">(<\/span><span class=\"nb\">int<\/span><span class=\"p\">)<\/span>  <span class=\"c1\"># Convertir tipo de datos\n<\/span>\n<span class=\"c1\"># Integraci\u00f3n de datos\n<\/span><span class=\"n\">df_combined<\/span> <span class=\"o\">=<\/span> <span class=\"n\">pd<\/span><span class=\"p\">.<\/span><span class=\"nf\">concat<\/span><span class=\"p\">([<\/span><span class=\"n\">df<\/span><span class=\"p\">,<\/span> <span class=\"n\">df_csv<\/span><span class=\"p\">],<\/span> <span class=\"n\">ignore_index<\/span><span class=\"o\">=<\/span><span class=\"bp\">True<\/span><span class=\"p\">)<\/span>\n\n<span class=\"c1\"># Transformaci\u00f3n de datos\n<\/span><span class=\"n\">df_combined<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">nueva_columna<\/span><span class=\"sh\">'<\/span><span class=\"p\">]<\/span> <span class=\"o\">=<\/span> <span class=\"n\">df_combined<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">columna1<\/span><span class=\"sh\">'<\/span><span class=\"p\">]<\/span> <span class=\"o\">+<\/span> <span class=\"n\">df_combined<\/span><span class=\"p\">[<\/span><span class=\"sh\">'<\/span><span class=\"s\">columna2<\/span><span class=\"sh\">'<\/span><span class=\"p\">]<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"3_%D8%A8%D8%A7%D8%B1%DA%AF%D8%B0%D8%A7%D8%B1%DB%8C_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  3. \u0628\u0627\u0631\u06af\u0630\u0627\u0631\u06cc \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0645\u0631\u062d\u0644\u0647 \u0628\u0627\u0631\u06af\u0630\u0627\u0631\u06cc \u0634\u0627\u0645\u0644 \u0627\u0646\u062a\u0642\u0627\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0634\u062f\u0647 \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u0645\u0642\u0635\u062f\u060c \u0645\u0627\u0646\u0646\u062f \u0627\u0646\u0628\u0627\u0631 \u062f\u0627\u062f\u0647 \u06cc\u0627 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u062a\u062d\u0644\u06cc\u0644\u06cc \u0627\u0633\u062a. \u0627\u06cc\u0646 \u0645\u0631\u062d\u0644\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0634\u0627\u0645\u0644 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u062c\u062f\u0627\u0648\u0644\u060c \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0631\u06a9\u0648\u0631\u062f\u0647\u0627\u06cc \u0645\u0648\u062c\u0648\u062f \u0648 \u063a\u06cc\u0631\u0647 \u0628\u0627\u0634\u062f.<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D9%85%D8%AB%D8%A7%D9%84-3\"><\/span>\n<p>  \u0645\u062b\u0627\u0644:<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight python\"><code><span class=\"c1\"># Carga de datos a una base de datos SQL\n<\/span><span class=\"n\">df_combined<\/span><span class=\"p\">.<\/span><span class=\"nf\">to_sql<\/span><span class=\"p\">(<\/span><span class=\"sh\">'<\/span><span class=\"s\">tabla_destino<\/span><span class=\"sh\">'<\/span><span class=\"p\">,<\/span> <span class=\"n\">engine<\/span><span class=\"p\">,<\/span> <span class=\"n\">if_exists<\/span><span class=\"o\">=<\/span><span class=\"sh\">'<\/span><span class=\"s\">replace<\/span><span class=\"sh\">'<\/span><span class=\"p\">,<\/span> <span class=\"n\">index<\/span><span class=\"o\">=<\/span><span class=\"bp\">False<\/span><span class=\"p\">)<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A7%D8%A8%D8%B2%D8%A7%D8%B1%D9%87%D8%A7%DB%8C_ETL\"><\/span>\n<p>  \u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc ETL<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u0628\u0632\u0627\u0631\u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f \u06a9\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f ETL \u0631\u0627 \u062a\u0633\u0647\u06cc\u0644 \u0645\u06cc \u06a9\u0646\u062f\u060c \u0628\u0631\u062e\u06cc \u0627\u0632 \u0645\u062d\u0628\u0648\u0628 \u062a\u0631\u06cc\u0646 \u0622\u0646\u0647\u0627 \u0639\u0628\u0627\u0631\u062a\u0646\u062f \u0627\u0632:<\/p>\n<ul>\n<li>\n<strong>Databricks<\/strong>: \u0628\u0633\u062a\u0631\u06cc \u0628\u0631\u0627\u06cc \u0627\u062c\u0631\u0627\u06cc \u06a9\u062f \u06a9\u0647 \u0627\u0645\u06a9\u0627\u0646 \u067e\u0631\u062f\u0627\u0632\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0641\u0631\u0627\u0647\u0645 \u0645\u06cc \u06a9\u0646\u062f.<\/li>\n<li>\n<strong>\u0622\u067e\u0627\u0686\u06cc \u0646\u06cc \u0641\u0627\u06cc<\/strong>: \u0627\u0628\u0632\u0627\u0631 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc.<\/li>\n<li>\n<strong>\u0627\u0633\u062a\u0639\u062f\u0627\u062f<\/strong>: \u067e\u0644\u062a \u0641\u0631\u0645 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u06a9\u0647 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc ETL \u0631\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f.<\/li>\n<li>\n<strong>\u0686\u0633\u0628 AWS<\/strong>: \u0633\u0631\u0648\u06cc\u0633 ETL \u06a9\u0627\u0645\u0644\u0627\u064b \u0645\u062f\u06cc\u0631\u06cc\u062a \u0634\u062f\u0647 \u062f\u0631 \u0627\u0628\u0631 AWS.<\/li>\n<li>\n<strong>\u062c\u0631\u06cc\u0627\u0646 \u0647\u0648\u0627\u06cc \u0622\u067e\u0627\u0686\u06cc<\/strong>: \u067e\u0644\u062a \u0641\u0631\u0645 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633\u06cc \u06af\u0631\u062f\u0634 \u06a9\u0627\u0631 \u06a9\u0647 \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u0628\u0631\u0627\u06cc \u0647\u0645\u0627\u0647\u0646\u06af\u06cc \u0641\u0631\u0622\u06cc\u0646\u062f\u0647\u0627\u06cc ETL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0634\u0648\u062f.<\/li>\n<li>\n<strong>\u06a9\u0627\u0631\u062e\u0627\u0646\u0647 \u062f\u0627\u062f\u0647<\/strong>: \u0647\u0645\u0627\u0647\u0646\u06af \u06a9\u0646\u0646\u062f\u0647 \u0641\u0631\u0622\u06cc\u0646\u062f \u062f\u0627\u062f\u0647 (\u062f\u0631\u06cc\u0627\u0641\u062a\u060c \u062a\u0628\u062f\u06cc\u0644 \u0648 \u0633\u0631\u0648\u06cc\u0633)<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"%D9%86%D8%AA%DB%8C%D8%AC%D9%87_%DA%AF%DB%8C%D8%B1%DB%8C\"><\/span>\n<p>  \u0646\u062a\u06cc\u062c\u0647 \u06af\u06cc\u0631\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0641\u0631\u0622\u06cc\u0646\u062f ETL \u0628\u0631\u0627\u06cc \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0633\u0627\u0632\u06cc \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a \u0648 \u0628\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u062e\u0627\u0645 \u0627\u062c\u0627\u0632\u0647 \u0645\u06cc \u062f\u0647\u062f \u062a\u0627 \u0628\u0647 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0627\u0631\u0632\u0634\u0645\u0646\u062f \u0628\u0631\u0627\u06cc \u062a\u0635\u0645\u06cc\u0645 \u06af\u06cc\u0631\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0634\u0648\u0646\u062f. \u0628\u0627 \u0627\u0628\u0632\u0627\u0631 \u0645\u0646\u0627\u0633\u0628 \u0648 \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc \u0645\u0646\u0627\u0633\u0628\u060c \u0641\u0631\u0622\u06cc\u0646\u062f ETL \u0645\u06cc \u062a\u0648\u0627\u0646\u062f \u06a9\u0627\u0631\u0622\u0645\u062f \u0648 \u0645\u0642\u06cc\u0627\u0633 \u067e\u0630\u06cc\u0631 \u0628\u0627\u0634\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Proceso de ETL (Extract, Transform, Load) \u0641\u0631\u0622\u06cc\u0646\u062f ETL (Extract, Transform, Load) \u062f\u0631 \u06cc\u06a9\u067e\u0627\u0631\u0686\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0633\u0627\u0633\u06cc \u0627\u0633\u062a \u0648 \u0628\u0631\u0627\u06cc \u0627\u0646\u062a\u0642\u0627\u0644 \u0648 \u062a\u0628\u062f\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0627\u0632 \u0645\u0646\u0627\u0628\u0639 \u0645\u062a\u0639\u062f\u062f \u0628\u0647 \u06cc\u06a9 \u0633\u06cc\u0633\u062a\u0645 \u0630\u062e\u06cc\u0631\u0647 \u0633\u0627\u0632\u06cc \u062f\u0627\u062f\u0647 \u0645\u0627\u0646\u0646\u062f \u0627\u0646\u0628\u0627\u0631 \u062f\u0627\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0647\u0631 \u0645\u0631\u062d\u0644\u0647 \u0627\u0632 \u0641\u0631\u0622\u06cc\u0646\u062f ETL \u062f\u0631 \u0632\u06cc\u0631 \u062a\u0648\u0636\u06cc\u062d \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a: 1. \u0627\u0633\u062a\u062e\u0631\u0627\u062c (\u0639\u0635\u0627\u0631\u0647) \u0645\u0631\u062d\u0644\u0647 &hellip;<\/p>\n","protected":false},"author":2,"featured_media":90907,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-90906","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/90906","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=90906"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/90906\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/90907"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=90906"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=90906"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=90906"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}