Python for Excel Book

Python for Excel

  • Author : Felix Zumstein
  • Publisher : "O'Reilly Media, Inc."
  • Release Date : 2021-03-04
  • Genre: Computers
  • Pages : 370
  • ISBN 10 : 9781492080954
  • Total Read : 59
  • File Size : 6,5 Mb

Python for Excel Summary:

While Excel remains ubiquitous in the business world, recent Microsoft feedback forums are full of requests to include Python as an Excel scripting language. In fact, it's the top feature requested. What makes this combination so compelling? In this hands-on guide, Felix Zumstein--creator of xlwings, a popular open source package for automating Excel with Python--shows experienced Excel users how to integrate these two worlds efficiently. Excel has added quite a few new capabilities over the past couple of years, but its automation language, VBA, stopped evolving a long time ago. Many Excel power users have already adopted Python for daily automation tasks. This guide gets you started. Use Python without extensive programming knowledge Get started with modern tools, including Jupyter notebooks and Visual Studio code Use pandas to acquire, clean, and analyze data and replace typical Excel calculations Automate tedious tasks like consolidation of Excel workbooks and production of Excel reports Use xlwings to build interactive Excel tools that use Python as a calculation engine Connect Excel to databases and CSV files and fetch data from the internet using Python code Use Python as a single tool to replace VBA, Power Query, and Power Pivot

Automate the Boring Stuff with Python  2nd Edition Book
Score: 4.5
From 2 Ratings

Automate the Boring Stuff with Python 2nd Edition

  • Author : Al Sweigart
  • Publisher : No Starch Press
  • Release Date : 2019-11-12
  • Genre: Computers
  • Pages : 592
  • ISBN 10 : 9781593279936
  • Total Read : 69
  • File Size : 8,8 Mb

Automate the Boring Stuff with Python 2nd Edition Summary:

The second edition of this best-selling Python book (over 500,000 copies sold!) uses Python 3 to teach even the technically uninclined how to write programs that do in minutes what would take hours to do by hand. There is no prior programming experience required and the book is loved by liberal arts majors and geeks alike. If you've ever spent hours renaming files or updating hundreds of spreadsheet cells, you know how tedious tasks like these can be. But what if you could have your computer do them for you? In this fully revised second edition of the best-selling classic Automate the Boring Stuff with Python, you'll learn how to use Python to write programs that do in minutes what would take you hours to do by hand--no prior programming experience required. You'll learn the basics of Python and explore Python's rich library of modules for performing specific tasks, like scraping data off websites, reading PDF and Word documents, and automating clicking and typing tasks. The second edition of this international fan favorite includes a brand-new chapter on input validation, as well as tutorials on automating Gmail and Google Sheets, plus tips on automatically updating CSV files. You'll learn how to create programs that effortlessly perform useful feats of automation to: • Search for text in a file or across multiple files • Create, update, move, and rename files and folders • Search the Web and download online content • Update and format data in Excel spreadsheets of any size • Split, merge, watermark, and encrypt PDFs • Send email responses and text notifications • Fill out online forms Step-by-step instructions walk you through each program, and updated practice projects at the end of each chapter challenge you to improve those programs and use your newfound skills to automate similar tasks. Don't spend your time doing work a well-trained monkey could do. Even if you've never written a line of code, you can make your computer do the grunt work. Learn

Data Wrangling with Python Book

Data Wrangling with Python

  • Author : Jacqueline Kazil
  • Publisher : "O'Reilly Media, Inc."
  • Release Date : 2016-02-04
  • Genre: Computers
  • Pages : 508
  • ISBN 10 : 9781491948774
  • Total Read : 84
  • File Size : 17,6 Mb

Data Wrangling with Python Summary:

How do you take your data analysis skills beyond Excel to the next level? By learning just enough Python to get stuff done. This hands-on guide shows non-programmers like you how to process information that’s initially too messy or difficult to access. You don't need to know a thing about the Python programming language to get started. Through various step-by-step exercises, you’ll learn how to acquire, clean, analyze, and present data efficiently. You’ll also discover how to automate your data process, schedule file- editing and clean-up tasks, process larger datasets, and create compelling stories with data you obtain. Quickly learn basic Python syntax, data types, and language concepts Work with both machine-readable and human-consumable data Scrape websites and APIs to find a bounty of useful information Clean and format data to eliminate duplicates and errors in your datasets Learn when to standardize data and when to test and script data cleanup Explore and analyze your datasets with new Python libraries and techniques Use Python solutions to automate your entire data-wrangling process

Python Programming On Win32 Book
Score: 3.5
From 2 Ratings

Python Programming On Win32

  • Author : Mark Hammond
  • Publisher : "O'Reilly Media, Inc."
  • Release Date : 2000
  • Genre: Computers
  • Pages : 652
  • ISBN 10 : 9781565926219
  • Total Read : 81
  • File Size : 16,7 Mb

Python Programming On Win32 Summary:

A demonstration of Python's basic technologies showcases the programming language's possiblities as a Windows development and administration tool.

Advancing Into Analytics Book

Advancing Into Analytics

  • Author : George Mount
  • Publisher : O'Reilly Media
  • Release Date : 2021-04-30
  • Genre: Computers
  • Pages : 250
  • ISBN 10 : 149209434X
  • Total Read : 70
  • File Size : 8,5 Mb

Advancing Into Analytics Summary:

Data analytics may seem daunting, but if you're familiar with Excel, you have a head start that can help you make the leap into analytics. Advancing into Analytics will lower your learning curve. Author George Mount, founder and CEO of Stringfest Analytics, clearly and gently guides intermediate Excel users to a solid understanding of analytics and the data stack. This book demonstrates key statistical concepts from spreadsheets and pivots your existing knowledge about data manipulation into R and Python programming. With this practical book at your side, you'll learn how to: Explore a dataset for potential research questions to check assumptions and to build hypotheses Make compelling business recommendations using inferential statistics Load, view, and write datasets using R and Python Perform common data wrangling tasks such as sorting, filtering, and aggregating using R and Python Navigate and execute code in Jupyter notebooks Identify, install, and implement the most useful open source packages for your needs And more

Foundations for Analytics with Python Book
Score: 5
From 1 Ratings

Foundations for Analytics with Python

  • Author : Clinton W. Brownley
  • Publisher : "O'Reilly Media, Inc."
  • Release Date : 2016-08-16
  • Genre: Business & Economics
  • Pages : 356
  • ISBN 10 : 9781491922507
  • Total Read : 86
  • File Size : 8,9 Mb

Foundations for Analytics with Python Summary:

If you’re like many of Excel’s 750 million users, you want to do more with your data—like repeating similar analyses over hundreds of files, or combining data in many files for analysis at one time. This practical guide shows ambitious non-programmers how to automate and scale the processing and analysis of data in different formats—by using Python. After author Clinton Brownley takes you through Python basics, you’ll be able to write simple scripts for processing data in spreadsheets as well as databases. You’ll also learn how to use several Python modules for parsing files, grouping data, and producing statistics. No programming experience is necessary. Create and run your own Python scripts by learning basic syntax Use Python’s csv module to read and parse CSV files Read multiple Excel worksheets and workbooks with the xlrd module Perform database operations in MySQL or with the mysqlclient module Create Python applications to find specific records, group data, and parse text files Build statistical graphs and plots with matplotlib, pandas, ggplot, and seaborn Produce summary statistics, and estimate regression and classification models Schedule your scripts to run automatically in both Windows and Mac environments

Hands On Enterprise Automation with Python Book

Hands On Enterprise Automation with Python

  • Author : Bassem Aly
  • Publisher : Packt Publishing Ltd
  • Release Date : 2018-06-28
  • Genre: Computers
  • Pages : 398
  • ISBN 10 : 9781788992640
  • Total Read : 87
  • File Size : 12,5 Mb

Hands On Enterprise Automation with Python Summary:

Invent your own Python scripts to automate your infrastructure Key Features Make the most of Python libraries and modules to automate your infrastructure Leverage Python programming to automate server configurations and administration tasks Efficiently develop your Python skill set Book Description Hands-On Enterprise Automation with Python starts by covering the set up of a Python environment to perform automation tasks, as well as the modules, libraries, and tools you will be using. We’ll explore examples of network automation tasks using simple Python programs and Ansible. Next, we will walk you through automating administration tasks with Python Fabric, where you will learn to perform server configuration and administration, along with system administration tasks such as user management, database management, and process management. As you progress through this book, you’ll automate several testing services with Python scripts and perform automation tasks on virtual machines and cloud infrastructure with Python. In the concluding chapters, you will cover Python-based offensive security tools and learn how to automate your security tasks. By the end of this book, you will have mastered the skills of automating several system administration tasks with Python. What you will learn Understand common automation modules used in Python Develop Python scripts to manage network devices Automate common Linux administration tasks with Ansible and Fabric Managing Linux processes Administrate VMware, OpenStack, and AWS instances with Python Security automation and sharing code on GitHub Who this book is for Hands-On Enterprise Automation with Python is for system administrators and DevOps engineers who are looking for an alternative to major automation frameworks such as Puppet and Chef. Basic programming knowledge with Python and Linux shell scripting is necessary.

Python for Data Analysis Book
Score: 5
From 1 Ratings

Python for Data Analysis

  • Author : Wes McKinney
  • Publisher : "O'Reilly Media, Inc."
  • Release Date : 2017-09-25
  • Genre: Computers
  • Pages : 676
  • ISBN 10 : 9781491957615
  • Total Read : 75
  • File Size : 5,5 Mb

Python for Data Analysis Summary:

Get complete instructions for manipulating, processing, cleaning, and crunching datasets in Python. Updated for Python 3.6, the second edition of this hands-on guide is packed with practical case studies that show you how to solve a broad set of data analysis problems effectively. You’ll learn the latest versions of pandas, NumPy, IPython, and Jupyter in the process. Written by Wes McKinney, the creator of the Python pandas project, this book is a practical, modern introduction to data science tools in Python. It’s ideal for analysts new to Python and for Python programmers new to data science and scientific computing. Data files and related material are available on GitHub. Use the IPython shell and Jupyter notebook for exploratory computing Learn basic and advanced features in NumPy (Numerical Python) Get started with data analysis tools in the pandas library Use flexible tools to load, clean, transform, merge, and reshape data Create informative visualizations with matplotlib Apply the pandas groupby facility to slice, dice, and summarize datasets Analyze and manipulate regular and irregular time series data Learn how to solve real-world data analysis problems with thorough, detailed examples