Python-Powered Excel : Combining the strengths of Python and Excel for deliverables and complex tasks

Description: Excel is the backbone of business, but its limitations with complex data and repetitive manual tasks hinder productivity. Python, the world's most versatile programming language, offers a powerful solution. By utilizing various tools, Excel users can move beyond basic spreadsheet f...

Descrizione completa

Salvato in:
Dettagli Bibliografici
Autore principale: Arora, Nisha
Natura: Livre numérique
Lingua:Anglais
Pubblicazione: New Delhi : BPB Publications 2026.
Paris : Cyberlibris
Accesso online:Accès Université d'Orléans et IFPM
Nota: Couverture. https://static2.cyberlibris.com/books_upload/300pix/9789378543555.jpg
Cyberlibris (ScholarVox) corpus Informatique
Autres localisations: Voir dans le Sudoc
Edition sous un autre format:• Python-Powered Excel, Combining the strengths of Python and Excel for deliverables and complex tasks, Dr Nisha Arora, New Delhi, BPB Publications, 2026, 1 vol. (457 p.), 978-93-7854-355-5
Sommario:
  • 1. Python for Excel Users
  • 2. Setting Up Python
  • 3. Python Fundamentals
  • 4. External Packages and Date-time Handling
  • 5. Automating File Management with Python
  • 6. Data Manipulation with Pandas
  • 7. Smart Tools for Faster Analysis
  • 8. Unlocking Excel with openpyxl
  • 9. Core Excel Read-Write Tools in Python
  • 10. Transitioning to xlwings for Excel Automation
  • 11. Running Python Code from Excel
  • 12. Advanced Automation with xlwings
  • 13. Python Excel Integration Limits and Vision
  • Appendix: Python Charts for Business Analysis