000			03211nam a2200277uu 4500
005			20250710181506.0
008			250616s||||||||||||||||o||||||||||| |d
024	8	0	_a9781804615546
040			_aPACKT _cPACKT
041			_aen
044			_aGB
100	0		_aSteven Sanderson _eauthor.
700	0		_aDavid Kun _eauthor.
710	2		_aPACKT
773	0		_tExtending Excel with Python and R _dGB,Packt,2024-04-30 _h344
245	0	0	_aExtending Excel with Python and R.
300			_a344.
377			_aen
260			_aGB: _bPackt, _c2024-04-30.
263			_a2024-04-30
264		1	_aGB: _bPackt,
520			_a<p><b>Seamlessly integrate the Python and R programming languages with spreadsheet-based data analysis to maximize productivity</b></p><h4>Key Features</h4><ul><li>Perform advanced data analysis and visualization techniques with R and Python on Excel data</li><li>Use exploratory data analysis and pivot table analysis for deeper insights into your data</li><li>Integrate R and Python code directly into Excel using VBA or API endpoints</li><li>Purchase of the print or Kindle book includes a free PDF eBook</li></ul><h4>Book Description</h4>– Extending Excel with Python and R is a game changer resource written by experts Steven Sanderson, the author of the healthyverse suite of R packages, and David Kun, co-founder of Functional Analytics. – This comprehensive guide transforms the way you work with spreadsheet-based data by integrating Python and R with Excel to automate tasks, execute statistical analysis, and create powerful visualizations. – Working through the chapters, you’ll find out how to perform exploratory data analysis, time series analysis, and even integrate APIs for maximum efficiency. – Both beginners and experts will get everything you need to unlock Excel's full potential and take your data analysis skills to the next level. – By the end of this book, you’ll be able to import data from Excel, manipulate it in R or Python, and perform the data analysis tasks in your preferred framework while pushing the results back to Excel for sharing with others as needed. <h4>What you will learn</h4><ul><li>Read and write Excel files with R and Python libraries</li><li>Automate Excel tasks with R and Python scripts</li><li>Use R and Python to execute Excel VBA macros</li><li>Format Excel sheets using R and Python packages</li><li>Create graphs with ggplot2 and Matplotlib in Excel</li><li>Analyze Excel data with statistical methods and time series analysis</li><li>Explore various methods to call R and Python functions from Excel</li></ul><h4>Who this book is for</h4>– If you’re a data analyst or data scientist, or a quants, actuaries, or data practitioner looking to enhance your Excel skills and expand your data analysis capabilities with R and Python, this book is for you. – The comprehensive approach to the topics covered makes it suitable for both beginners and intermediate learners. – A basic understanding of Excel, Python, and R is all you need to get started. .
538			_aData in extended ASCII character set.
538			_aMode of access: Internet.
856	4	0	_uhttps://learning.packt.com/product/471546
999			_c15147 _d15147