What do you think?
Rate this book
Python Lab1 Excel openpyxl: Visual Programming
#1 New Release Black and White Edition.
Are you curious about the Python language and wondering how to read and write Excel files? This book is a hands-on lab with simple code examples that perform one basic compare two Excel files and output an Excel file of differences. At the end of the lab, you will know enough about Python to work with your own Excel files, even if you’re new to Python or programming.
My examples use the free Anaconda data science platform Python 3.7, running on a Windows computer, utilizing the Spyder application. The step-by-step examples walk through each line of code, with screenshots of the corresponding Excel files so you can follow along as the program moves through the code. In the course of the lab, you’ll learn these Python concepts.
Please note, I don’t attempt to cover all aspects of Python, only those concepts needed to complete this lab. If you said, "Show me what I need to start using Python with Excel files" this lab answers that simple question. After you complete the lab, you’ll definitely be able to say you can program in Python.
Python is really powerful, and I hope you enjoy the lab and want to continue to expand your Python skills in the future.In my opinion, a working code example takes all the guesswork out of programming, leaving just the fun of learning something new. You don’t have to wonder if you have the correct indentation, your counter is in the right place, or if you forgot the colon at the end of the line when you defined your function.
Are you ready? Let’s get started!
Are you curious about the Python language and wondering how to read and write Excel files? This book is a hands-on lab with simple code examples that perform one basic compare two Excel files and output an Excel file of differences. At the end of the lab, you will know enough about Python to work with your own Excel files, even if you’re new to Python or programming.
My examples use the free Anaconda data science platform Python 3.7, running on a Windows computer, utilizing the Spyder application. The step-by-step examples walk through each line of code, with screenshots of the corresponding Excel files so you can follow along as the program moves through the code. In the course of the lab, you’ll learn these Python concepts.
Please note, I don’t attempt to cover all aspects of Python, only those concepts needed to complete this lab. If you said, "Show me what I need to start using Python with Excel files" this lab answers that simple question. After you complete the lab, you’ll definitely be able to say you can program in Python.
Python is really powerful, and I hope you enjoy the lab and want to continue to expand your Python skills in the future.In my opinion, a working code example takes all the guesswork out of programming, leaving just the fun of learning something new. You don’t have to wonder if you have the correct indentation, your counter is in the right place, or if you forgot the colon at the end of the line when you defined your function.
Are you ready? Let’s get started!
84 pages, Paperback
Published November 24, 2019
9 people are currently reading
5 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
No one has reviewed this book yet.