{"id":86,"date":"2023-08-23T10:30:35","date_gmt":"2023-08-23T10:30:35","guid":{"rendered":"https:\/\/tastycounter.net\/index.php\/2023\/08\/23\/microsoft-excel-cong-bo-tich-hop-python-da-co-the-trai-nghiem\/"},"modified":"2023-08-23T10:30:35","modified_gmt":"2023-08-23T10:30:35","slug":"microsoft-excel-cong-bo-tich-hop-python-da-co-the-trai-nghiem","status":"publish","type":"post","link":"https:\/\/tastycounter.net\/index.php\/2023\/08\/23\/microsoft-excel-cong-bo-tich-hop-python-da-co-the-trai-nghiem\/","title":{"rendered":"Microsoft Excel c\u00f4ng b\u1ed1 t\u00edch h\u1ee3p Python, \u0111\u00e3 c\u00f3 th\u1ec3 tr\u1ea3i nghi\u1ec7m"},"content":{"rendered":"<\/p>\n
\n

Microsoft l\u1ea7n \u0111\u1ea7u ti\u00ean ra m\u1eaft b\u1ea3n beta Excel t\u00edch h\u1ee3p Python<\/a> cho ng\u01b0\u1eddi d\u00f9ng n\u1ed9i b\u1ed9 Microsoft 365. V\u1edbi s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a th\u01b0 vi\u1ec7n Python, ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng Excel \u0111\u1ec3 ph\u00e2n t\u00edch v\u00e0 tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n.<\/p>\n

Microsoft cho bi\u1ebft, hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh Python ch\u1ec9 kh\u1ea3 d\u1ee5ng trong phi\u00ean b\u1ea3n Excel d\u00e0nh cho m\u00e1y t\u00ednh \u0111\u1ec3 b\u00e0n v\u00e0 c\u00f3 th\u1ec3 ch\u1ea1y trong \u0111\u00e1m m\u00e2y c\u1ee7a h\u00e3ng.<\/p>\n

Hi\u1ec7n t\u1ea1i, ng\u01b0\u1eddi d\u00f9ng n\u1ebfu mu\u1ed1n tr\u1ea3i nghi\u1ec7m c\u00e1c ph\u00e9p t\u00ednh Python tr\u00ean Excel c\u00f3 th\u1ec3 t\u1ea3i c\u00e1c b\u1ea3n d\u1ef1ng Excel m\u1edbi nh\u1ea5t b\u1eb1ng c\u00e1ch tham gia ch\u01b0\u01a1ng tr\u00ecnh Ng\u01b0\u1eddi d\u00f9ng n\u1ed9i b\u1ed9 Microsoft 365 v\u00e0 ch\u1ecdn k\u00eanh Beta.<\/p>\n

\"V\u00ed
V\u00ed d\u1ee5 v\u1ec1 Python trong Excel. \u1ea2nh: Microsoft.<\/figcaption><\/figure>\n

V\u1edbi Python \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p nguy\u00ean b\u1ea3n v\u00e0o l\u01b0\u1edbi Excel, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m “=PY” m\u1edbi \u0111\u1ec3 nh\u1eadp m\u00e3 Python tr\u1ef1c ti\u1ebfp v\u00e0o c\u00e1c \u00f4 Excel. Ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng Python li\u1ec1n m\u1ea1ch trong c\u00e1c c\u00f4ng th\u1ee9c, bi\u1ec3u \u0111\u1ed3 v\u00e0 PivotTable trong Excel.<\/p>\n

B\u1eb1ng c\u00e1ch t\u00edch h\u1ee3p c\u00e1c h\u00e0m Python trong Excel, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c th\u01b0 vi\u1ec7n Python nh\u01b0 g\u1ea5u tr\u00fac, matplotlib v\u00e0 scikit-learning\u2026 \u0111\u1ec3 tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u, l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u, h\u1ecdc m\u00e1y v\u00e0 ph\u00e2n t\u00edch d\u1ef1 \u0111o\u00e1n.<\/p>\n

<\/ins><\/div>\n
\"H\u00e0m
H\u00e0m PY() v\u00e0 t\u1ea5t c\u1ea3 s\u1ef1 k\u1ef3 di\u1ec7u c\u1ee7a Python s\u1ebd c\u00f3 m\u1eb7t trong Excel.<\/figcaption><\/figure>\n

Python t\u00edch h\u1ee3p c\u1ee7a Excel \u0111\u1ebfn t\u1eeb b\u1ea3n ph\u00e2n ph\u1ed1i Anaconda.<\/p>\n

Peter Wang, Gi\u00e1m \u0111\u1ed1c \u0111i\u1ec1u h\u00e0nh v\u00e0 \u0111\u1ed3ng s\u00e1ng l\u1eadp Anaconda cho bi\u1ebft, vi\u1ec7c t\u00edch h\u1ee3p b\u1ea3n ph\u00e2n ph\u1ed1i Anaconda c\u1ee7a Python v\u00e0o Microsoft Excel l\u00e0 m\u1ed9t b\u01b0\u1edbc \u0111\u1ed9t ph\u00e1, s\u1ebd khi\u1ebfn quy tr\u00ecnh l\u00e0m vi\u1ec7c c\u1ee7a h\u00e0ng tri\u1ec7u ng\u01b0\u1eddi d\u00f9ng Excel tr\u00ean to\u00e0n th\u1ebf gi\u1edbi thay \u0111\u1ed5i. Ngo\u00e0i ra, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 th\u00f4ng qua c\u00e1c c\u00f4ng c\u1ee5 nh\u01b0 Microsoft Teams v\u00e0 Outlook \u0111\u1ec3 chia s\u1ebb file c\u00f4ng vi\u1ec7c ch\u1ee9a m\u00e3 Python v\u1edbi c\u00e1c th\u00e0nh vi\u00ean trong nh\u00f3m.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Microsoft l\u1ea7n \u0111\u1ea7u ti\u00ean ra m\u1eaft b\u1ea3n beta Excel t\u00edch h\u1ee3p Python cho ng\u01b0\u1eddi d\u00f9ng n\u1ed9i b\u1ed9 Microsoft 365. V\u1edbi s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a th\u01b0 vi\u1ec7n Python, ng\u01b0\u1eddi d\u00f9ng s\u1eed d\u1ee5ng Excel \u0111\u1ec3 ph\u00e2n t\u00edch v\u00e0 tr\u1ef1c quan h\u00f3a d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n. Microsoft cho bi\u1ebft, hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh Python ch\u1ec9 kh\u1ea3 d\u1ee5ng […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-86","post","type-post","status-publish","format-standard","hentry","category-khong-phan-loai"],"_links":{"self":[{"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/posts\/86","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/comments?post=86"}],"version-history":[{"count":0,"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/posts\/86\/revisions"}],"wp:attachment":[{"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/media?parent=86"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/categories?post=86"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tastycounter.net\/index.php\/wp-json\/wp\/v2\/tags?post=86"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}