Python for Excel : A Modern Environment for Automation and Data Analysis

Λεπτομέρειες βιβλιογραφικής εγγραφής
Τίτλος: Python for Excel : A Modern Environment for Automation and Data Analysis
Περιγραφή: Professionals in nearly every industry use Excel to create powerful tools that can adapt quickly to fast-changing environments. But Excel's automation language, VBA, stopped evolving a long time ago. Python, on the other hand, has exploded in popularity, so Microsoft's official Python integration came as no surprise. This thoroughly revised hands-on guide helps you unlock Excel's full potential using Python. Analysts, engineers, data scientists, and other power users will learn how to extend Excel's powerful analytics engine with Microsoft's Python in Excel feature. And with Excel's AI Copilot tool, even Python newbies can easily accomplish advanced tasks. Author Felix Zumstein—creator of the popular open source package xlwings—also dives into complementary solutions, including xlwings and OpenPyXL, that make the most of the combined capabilities of Excel and Python. Learn how to use Python's core features Get started with modern tools, including Jupyter notebooks and Visual Studio Code Apply powerful pandas commands to acquire, clean, and analyze data Use advanced analytics via pandas in Excel, using Python in Excel Manipulate Excel files with Python, using xlwings and OpenPyXL Automate Excel with Python, using xlwings and xlwings Lite
Συγγραφείς: Felix Zumstein
Resource Type: eBook.
Categories: COMPUTERS / Business & Productivity Software / Spreadsheets, COMPUTERS / Data Science / General, COMPUTERS / Programming / General, COMPUTERS / Languages / Python, COMPUTERS / Business & Productivity Software / Databases
Βάση Δεδομένων: eBook Index
FullText Text:
  Availability: 0
Header DbId: edsebk
DbLabel: eBook Index
An: 4494813
RelevancyScore: 987
AccessLevel: 6
PubType: eBook
PubTypeId: ebook
PreciseRelevancyScore: 987.310668945313
IllustrationInfo
Items – Name: Title
  Label: Title
  Group: Ti
  Data: Python for Excel : A Modern Environment for Automation and Data Analysis
– Name: Abstract
  Label: Description
  Group: Ab
  Data: Professionals in nearly every industry use Excel to create powerful tools that can adapt quickly to fast-changing environments. But Excel's automation language, VBA, stopped evolving a long time ago. Python, on the other hand, has exploded in popularity, so Microsoft's official Python integration came as no surprise. This thoroughly revised hands-on guide helps you unlock Excel's full potential using Python. Analysts, engineers, data scientists, and other power users will learn how to extend Excel's powerful analytics engine with Microsoft's Python in Excel feature. And with Excel's AI Copilot tool, even Python newbies can easily accomplish advanced tasks. Author Felix Zumstein—creator of the popular open source package xlwings—also dives into complementary solutions, including xlwings and OpenPyXL, that make the most of the combined capabilities of Excel and Python. Learn how to use Python's core features Get started with modern tools, including Jupyter notebooks and Visual Studio Code Apply powerful pandas commands to acquire, clean, and analyze data Use advanced analytics via pandas in Excel, using Python in Excel Manipulate Excel files with Python, using xlwings and OpenPyXL Automate Excel with Python, using xlwings and xlwings Lite
– Name: Author
  Label: Authors
  Group: Au
  Data: <searchLink fieldCode="AR" term="%22Felix+Zumstein%22">Felix Zumstein</searchLink>
– Name: TypePub
  Label: Resource Type
  Group: TypPub
  Data: eBook.
– Name: SubjectBISAC
  Label: Categories
  Group: Su
  Data: <searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Business+%26+Productivity+Software+%2F+Spreadsheets%22">COMPUTERS / Business & Productivity Software / Spreadsheets</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Data+Science+%2F+General%22">COMPUTERS / Data Science / General</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Programming+%2F+General%22">COMPUTERS / Programming / General</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Languages+%2F+Python%22">COMPUTERS / Languages / Python</searchLink><br /><searchLink fieldCode="ZK" term="%22COMPUTERS+%2F+Business+%26+Productivity+Software+%2F+Databases%22">COMPUTERS / Business & Productivity Software / Databases</searchLink>
PLink https://search.ebscohost.com/login.aspx?direct=true&site=eds-live&db=edsebk&AN=4494813
RecordInfo BibRecord:
  BibEntity:
    Languages:
      – Code: eng
        Text: English
    Titles:
      – TitleFull: Python for Excel : A Modern Environment for Automation and Data Analysis
        Type: main
  BibRelationships:
    HasContributorRelationships:
      – PersonEntity:
          Name:
            NameFull: Felix Zumstein
      – PersonEntity:
          Name:
            NameFull: Felix Zumstein
    IsPartOfRelationships:
      – BibEntity:
          Dates:
            – D: 01
              M: 01
              Type: published
              Y: 2026
          Identifiers:
            – Type: isbn-print
              Value: 9798341640290
            – Type: isbn-electronic
              Value: 9798341640269
            – Type: isbn-electronic
              Value: 9798341640276
          Titles:
            – TitleFull: Python for Excel : A Modern Environment for Automation and Data Analysis
              Type: main
ResultId 1