Try Python - For Excel Developers - Book 1

by David Rojas, Mikaela Rojas (Editor)

Overview

Excel is probably the most popular data analysis tool in the market and most people, including myself, started their data career working with Excel. This book is for the casual Microsoft Excel user that is interested in learning Python. Python is gaining a lot of ground and becoming the go-to software for data analysis. If you are not a programmer or even an engineer, then this book has been created just for you. The examples below will assume you have never programmed before and will try to mimic similar tasks you would normally perform using Excel. Step-by-step instructions are provided and the examples are short so you can read this book in one sitting. After reading the book you should be able to perform a lot of the data analysis you do in Excel but using Python instead. Enjoy!

What Will you Learn



How to import Python libraries

How to create data using Pandas

How to create new columns

How to sum horizontally

How to compute averages

How to calculate percentages

How to sort data

How to filter data

How to create plots and charts using MatPlotLib



Tags: python windows, ipython notebook, learn python, jupyter, pandas, python excel

Product Details

BN ID:	2940157922740
Publisher:	David Rojas
Publication date:	04/03/2016
Sold by:	Barnes & Noble
Format:	eBook
File size:	343 KB

About the Author

David Rojas is a data enthusiast and Python evangelist. Currently, he is enjoying his time as a consultant in the data world. He lives in the Silicon Valley and is active within the data community. After receiving a degree from the University of Florida as an industrial and systems engineer and obtaining a minor in sales engineering, he received his state license as an engineer in training. Soon thereafter, he pursued a career change to the IT world as a data analyst and discovered his passion for data using various tools in order to manage and analyze data in a better way. After many years of working in a wide range of odd data roles, such as reporting, gathering requirements, writing documentation, working with databases, and working with flat files, he decided to make his love for data a reality and started his own business (www.hedaro.com). You will often find his work being cited by various professors and other data enthusiasts around the Bay Area.