techcommunity.microsoft.com - Thông báo Python kết hợp trong Excel

Thảo luận trong 'Thư Giãn Express - Bản Tin Cuối Ngày' bắt đầu bởi Nh0c_K3n, 26/8/23.

  1. Nh0c_K3n

    Nh0c_K3n The Warrior of Light Lão Làng GVN

    Tham gia ngày:
    20/10/08
    Bài viết:
    2,027
    Nơi ở:
    Aden
    Kể từ khi thành lập, Microsoft Excel đã thay đổi cách mọi người sắp xếp, phân tích và trực quan hóa dữ liệu của họ, cung cấp cơ sở cho việc ra quyết định cho hàng triệu người sử dụng nó mỗi ngày. Hôm nay, chúng tôi xin công bố sự phát triển đáng kể về khả năng phân tích sẵn có trong Excel bằng cách phát hành Bản xem trước công khai của Python trong Excel. Python trong Excel giúp bạn có thể kết hợp các phân tích Python và Excel trong cùng một sổ làm việc - không cần thiết lập. Với Python trong Excel, bạn có thể nhập Python trực tiếp vào một ô, các phép tính Python chạy trong Microsoft Cloud và kết quả của bạn sẽ được trả về trang tính, bao gồm các biểu đồ và hình ảnh trực quan.

    https://techcommunity.microsoft.com...ning-the-power-of-python-and-the/ba-p/3893439

    Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the millions of people who use it each day. Today we’re announcing a significant evolution in the analytical capabilities available within Excel by releasing a Public Preview of Python in Excel. Python in Excel makes it possible to natively combine Python and Excel analytics within the same workbook - with no setup required. With Python in Excel, you can type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations.



    [​IMG]Seamlessly aggregate and visualize your data with Python in Excel.



    Python in Excel is rolling out to Public Preview for those in the Microsoft 365 Insiders program, using the Beta Channel in Excel for Windows.



    Watch Python in Excel in action and learn more below:




    What sets Python in Excel apart?
    1. Python in Excel is built for analysts.

    Every day millions of users around the world rely on familiar Excel tools such as formulas, charts, and PivotTables to analyze and understand their data. Starting today, Python in Excel will also be natively integrated directly into the Excel grid. To get started simply use the new PY function which allows you to input Python code directly into Excel cells.



    [​IMG]Create DataFrames with a few simple clicks.





    Excel users now have access to powerful analytics via Python for visualizations, cleaning data, machine learning, predictive analytics, and more. Users can now create end to end solutions that seamlessly combine Excel and Python – all within Excel. Using Excel’s built-in connectors and Power Query, users can easily bring external data into Python in Excel workflows. Python in Excel is compatible with the tools users already know and love, such as formulas, PivotTables, and Excel charts.



    Here are some examples of the types of analysis that are now possible with Python in Excel:



    Advanced Visualizations

    Tap into the potential of well-known Python charting libraries like Matplotlib and seaborn to create a wide variety of charts, spanning from conventional bar graphs and line plots to specialized visualizations such as heatmaps, violin plots, and swarm plots.



    [​IMG]Pair plot using Seaborn.





    Machine Learning, Predictive Analytics, and Forecasting

    Leverage the capabilities of Python libraries like scikit-learn and statsmodels to apply popular machine learning, predictive analytics, and forecasting techniques such as regression analysis, time series modeling, and more.



    [​IMG]Machine Learning model predicting the weather using Python and Excel LAMBDA.



    Data Cleaning

    Make efficient use of advanced data cleaning techniques such as locating missing values, standardizing formats, removing duplicates, and employing techniques like regular expressions for pattern-based transformations.



    [​IMG]Date extraction using regular expressions.





    2. Python in Excel exposes the best of Python analytics via Anaconda.

    Anaconda is a leading enterprise Python repository used by tens of millions of data practitioners worldwide. Python in Excel leverages Anaconda Distribution for Python running in Azure, which includes the most popular Python libraries (e.g. pandas, Matplotlib, scikit-learn, etc.), and is securely built, tested, and supported by Anaconda. Python provided by Anaconda supports a wide array of analytics with Python in Excel.






    "I am thrilled to announce the integration of Anaconda Distribution for Python into Microsoft Excel – a major breakthrough that will transform the workflow of millions of Excel users around the world.” said Anaconda CEO and co-founder Peter Wang.



    3. Python in Excel runs securely on the Microsoft Cloud, with no setup required.

    Python code used by Excel runs on the Microsoft Cloud with enterprise-level security as a compliant Microsoft 365 connected experience. The Python code runs in its own hypervisor isolated container using Azure Container Instances and secure, source-built packages from Anaconda through a secure software supply chain. Python in Excel keeps your data private by preventing the Python code from knowing who you are, and opening workbooks from the internet in further isolation within their own separate containers. Data from your workbooks can only be sent via the built-in xl() Python function, and the output of the Python code can only be returned as the result of the =PY() Excel function.

    Learn more about our Data Security



    4. Python in Excel is built for teams.

    Users can share Python in Excel workbooks with confidence. Teammates can seamlessly interact with and refresh Python in Excel based analytics without needing to worry about installing additional tools, Python runtimes, or managing libraries and dependencies. Users can share workbooks using their favorite collaboration tools such as Microsoft Teams and Microsoft Outlook and work together seamlessly via comments, @ mentions, and co-authoring with colleagues as they normally would in Excel. Sensitivity labels applied to your workbooks containing Python will keep them compliant with your organization's information protection policies.






    5. Python in Excel reflects Microsoft’s deep commitment to Python.

    Python in Excel was crafted thanks to a close partnership across multiple teams at Microsoft, including Microsoft Excel, Microsoft Developer Division, Microsoft Security, Microsoft Azure, and Microsoft Research. This project reflects the importance of Python to Microsoft and our commitment to collaborate with the Python community as well as making Python better and more accessible for everyone.


    Guido van Rossum, Python’s creator, emeritus BDFL and now Microsoft Distinguished Engineer, has helped define the architecture for Python in Excel. Here’s his reaction to the Public Preview:


    "I’m excited that this excellent, tight integration of Python and Excel is now seeing the light of day. I expect that both communities will find interesting new uses in this collaboration, amplifying each partner's abilities. When I joined Microsoft three years ago, I would not have dreamed this would be possible. The Excel team excels!"






    See what customers and partners are already saying about Python in Excel



    McGraw Hill - “McGraw Hill’s ethos is education for all, and our partnership with Microsoft has helped improve student access to Excel tools, building career readiness. Python is one of the most in-demand skills we’re hearing from colleges and universities, and we’re thrilled that Python in Excel will provide educators and students with a powerful new gateway to move faster with analytics, enable greater collaboration and learning, and ultimately bridge students to even brighter futures.” - Rebecca Olson, Sr. Portfolio Director






    McKinney - “The ability to run Python in Excel simplifies McKinney's reporting workflows. We used to manipulate data structures, filter, and aggregate data in a Jupyter Notebook, and build visuals in Excel. Now we can manage the entire workflow in Excel. This is going to make Excel that much more powerful and make Python more accessible across the organization. Python support is the most exciting update for Excel in my career!” - Greg Barnes, Executive Director of Data and Analytics




    KPMG - “KPMG and Microsoft are making significant investments to deliver advanced cloud-based tax technologies. At KPMG, we’re excited about the impact Python in Excel will have for our Tax clients. Backed by the data and security promises enabled by the Microsoft cloud, Python has the potential to enhance the Excel experience for advanced analytics while providing companies with transparency, simplicity and deeper insights into their financials.”– Tejas Varia, Principal, Tax Data & Analytics



    Get started with Python in Excel
    Python in Excel is gradually rolling out to users running Beta Channel on Windows. This feature will roll out to Excel for Windows first, starting with build 16.0.16818.20000, and then to the other platforms at a later date.



    To use Python in Excel, join the Microsoft 365 Insider Program. Choose the Beta Channel Insider level to get the latest builds of the Excel application.  



    Don’t have it yet? It’s probably us, not you. Features are released over time to ensure things are working smoothly. We highlight features that you may not have because they’re slowly releasing to larger numbers of Insiders. Sometimes we remove elements for further improvement based on your feedback. Though this is rare, we also reserve the option to pull a feature entirely out of the product even if you, as an Insider, have had the opportunity to try it.


    While in Preview, Python in Excel will be included with your Microsoft 365 subscription. After the Preview, some functionality will be restricted without a paid license. More details will be available before General Availability.





    We want your feedback!
    Excel and Python users can give feedback directly within the application (go to Help > Feedback), suggest improvements on our Feedback portal, or engage with our team on GitHub.


    What to expect next

    As mentioned above, we’re releasing Python in Excel as a Public Preview to the Insiders Beta Channel so you should expect new capabilities to light up soon. Stay tuned for updates on the following areas: improved editing experiences (such as autocomplete and syntax highlighting), default Reprs, enhanced error behaviors, help and documentation, and more. In addition, to prevent abuse, the system currently has some data size and compute limitations that we will closely monitor and adjust.

     
    Matsu thích bài này.
  2. Kronpas1997

    Kronpas1997 Baldur's Gate Lão Làng GVN

    Tham gia ngày:
    5/9/02
    Bài viết:
    30,836
    Cho khách hàng bussiness xài 365?

    Python code chạy trên cloud, không phải trên excel. Lại tốn thêm tiền thuê dichj vụ?
     
  3. lovelybear

    lovelybear The Lone Traveler from Vault 101 Lão Làng GVN

    Tham gia ngày:
    2/1/05
    Bài viết:
    17,727
    365 cũng 365 this 365 that mà... như ai được cty cho cái account business thì riêng cái khoản link data thôi nó đã nhàn hơn hẳn thằng personal rồi, như business là cái đường link nó gọn đẹp, thao tác y chang lấy data trên chính máy mình, lấy được cả folder luôn.... còn personal 365 thì ôi thôi.. phải biến đổi link các kiểu

    Cũng đang tính rảnh rỗi học python ứng dụng excel

    P.S.: Mới được kiểm tra kỹ năng excel bằng 1 bài hỏi Vlookup khi đi phỏng vấn... power quẻry cái xong rớt cmn luôn vì em chấm bài tưởng mình điền tay kết quả... hí hí hí
     
    jumper thích bài này.
  4. Red Mosnter

    Red Mosnter Red, Pokémon Champion ‍ ⚚ Mystic Mage ⚚ GVN Dalit

    Tham gia ngày:
    20/8/03
    Bài viết:
    42,490
    Đè nó ra híp là đậu rồi
     
  5. oldangelvn

    oldangelvn Godslayer Κράτος CHAMPION ⚜ Duel Master ⚜ Lão Làng GVN

    Tham gia ngày:
    7/9/05
    Bài viết:
    14,965
    Nơi ở:
    Hồ Chí Minh
    gặp ta ko biết cũng cho rớt vì ko thấy vlookup đâu, lạc đề pu_pepesniper
     
  6. lovelybear

    lovelybear The Lone Traveler from Vault 101 Lão Làng GVN

    Tham gia ngày:
    2/1/05
    Bài viết:
    17,727
    Tôi cần việc làm chứ tôi có cần 1 slot nhà nước nuôi đâu mà anh hướng dẫn vậy....
    Sức tôi không đủ khả năng chào buồng đâu.... !sad
     
  7. lovelybear

    lovelybear The Lone Traveler from Vault 101 Lão Làng GVN

    Tham gia ngày:
    2/1/05
    Bài viết:
    17,727
    đệt... có khi nào bữa giờ đi pv rớt đồm độp là do lý do này ko ta... tại ta dị ứng vlookup, nên nếu công thức cũng index match là giá chót.... !sad
     
  8. lehmanbear

    lehmanbear Kỹ sư gọi bưởi Lão Làng GVN

    Tham gia ngày:
    12/12/10
    Bài viết:
    17,900
    Đọc thấy bọn doanh nghiệp sợ mất data nếu online.
    Mong Microsoft sẽ cho dùng offline trg tương lai.
     
    Odisey and lovelybear like this.
  9. oldangelvn

    oldangelvn Godslayer Κράτος CHAMPION ⚜ Duel Master ⚜ Lão Làng GVN

    Tham gia ngày:
    7/9/05
    Bài viết:
    14,965
    Nơi ở:
    Hồ Chí Minh
    dc nhưng rối, ko tiện lợi + thao tác tốn thời gian...nếu vị trí trưởng + phó thì oki a giỏi, nv thì tạch tiếp...hay phỏng vấn nên ta biết, loại thẳng.
     
  10. lovelybear

    lovelybear The Lone Traveler from Vault 101 Lão Làng GVN

    Tham gia ngày:
    2/1/05
    Bài viết:
    17,727
    NV thì ai cần nhỉ, chả phải thằng sếp phải làm cái form sẵn rồi NV nhập liệu vào thôi saobietgidau
    Form mình yêu cầu nhập liệu chả mấy khi có công thức, muốn gì thì lấy data từ nó, vậy cho nhẹ file, linh động, module hóa luôn
    Ko thích Index match thì Xlookup cho hợp thời cũng được mà... chodima
     
    jumper thích bài này.
  11. lovelybear

    lovelybear The Lone Traveler from Vault 101 Lão Làng GVN

    Tham gia ngày:
    2/1/05
    Bài viết:
    17,727
    Sợ thì sợ thiệt nhưng ưu điểm của online giờ nó mạnh quá, offline sao so bì được
    Như mình nè, chỉ cần ở cty có đứa nhập dữ liệu thô đầy đủ, ngồi đâu mở file báo cáo lên là nó update sống luônchodima
     
  12. oldangelvn

    oldangelvn Godslayer Κράτος CHAMPION ⚜ Duel Master ⚜ Lão Làng GVN

    Tham gia ngày:
    7/9/05
    Bài viết:
    14,965
    Nơi ở:
    Hồ Chí Minh
    ah nguyên tắc tuyển dụng đa phần cần nv nghe hiểu trước, khi nào cần sáng tạo thì sẽ hỏi, còn thí dụ hỏi A làm cách B thì cũng dc nhưng phải xét trường hợp: B này mình ko rành thôi mình ngunó giỏi cho rớt vô nó dạy mình nữa, B này làm tốn thời gian hơn A hay không...phiền lắm.
     
    lovelybear thích bài này.
  13. lehmanbear

    lehmanbear Kỹ sư gọi bưởi Lão Làng GVN

    Tham gia ngày:
    12/12/10
    Bài viết:
    17,900
    flex làm sếp đóvayha-gif
     
    lovelybear thích bài này.
  14. jumper

    jumper Baldur's Gate Lão Làng GVN

    Tham gia ngày:
    5/6/03
    Bài viết:
    26,960
    M$ định hướng tương lai cloud 100%
    Từ office đến win cũng có cloud :)))
    data lake, data warehouse, Bi các kiểu lên cloud tuốt
    Erp (dynamic 365) cũng cloud lun
    gói 365 enterprise xịn xò vkl luôn
     
  15. lovelybear

    lovelybear The Lone Traveler from Vault 101 Lão Làng GVN

    Tham gia ngày:
    2/1/05
    Bài viết:
    17,727
    Enterprise gói E hay sao nó bonus cho Visio luôn, tha hồ vẽ vời hù dọa mấy em yếu kỹ năng VP
    Như Vísio mà update data từ Excel, hay word update data từ excel (ờ mà rảnh thật, tự nhiên bữa ngồi làm cái file Word xong update data từ excel, làm xong file mới nhớ ra... sao ko qua Excel làm luôn từ đầu cho rồi)
     
  16. Kronpas1997

    Kronpas1997 Baldur's Gate Lão Làng GVN

    Tham gia ngày:
    5/9/02
    Bài viết:
    30,836
    Comment thôi, chứ xu hướng này là đương nhiên rồi.
     
    lovelybear thích bài này.
  17. jumper

    jumper Baldur's Gate Lão Làng GVN

    Tham gia ngày:
    5/6/03
    Bài viết:
    26,960
    E chỉ có view tthô
    Visio + project vẫn phải mua

    mà xaid draw.io cho khoẻ
     
  18. Dem Tiện Bất Năng Di

    Dem Tiện Bất Năng Di Fire in the hole!

    Tham gia ngày:
    12/12/22
    Bài viết:
    2,949
    Học excel thì cứ youtube thôi hả ae
     

Chia sẻ trang này