Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Extending Excel with Python and R

You're reading from  Extending Excel with Python and R

Product type Book
Published in Apr 2024
Publisher Packt
ISBN-13 9781804610695
Pages 344 pages
Edition 1st Edition
Languages
Authors (2):
Steven Sanderson Steven Sanderson
Profile icon Steven Sanderson
David Kun David Kun
Profile icon David Kun
View More author details

Table of Contents (20) Chapters

Preface Part 1:The Basics – Reading and Writing Excel Files from R and Python
Chapter 1: Reading Excel Spreadsheets Chapter 2: Writing Excel Spreadsheets Chapter 3: Executing VBA Code from R and Python Chapter 4: Automating Further – Task Scheduling and Email Part 2: Making It Pretty – Formatting, Graphs, and More
Chapter 5: Formatting Your Excel Sheet Chapter 6: Inserting ggplot2/matplotlib Graphs Chapter 7: Pivot Tables and Summary Tables Part 3: EDA, Statistical Analysis, and Time Series Analysis
Chapter 8: Exploratory Data Analysis with R and Python Chapter 9: Statistical Analysis: Linear and Logistic Regression Chapter 10: Time Series Analysis: Statistics, Plots, and Forecasting Part 4: The Other Way Around – Calling R and Python from Excel
Chapter 11: Calling R/Python Locally from Excel Directly or via an API Part 5: Data Analysis and Visualization with R and Python for Excel Data – A Case Study
Chapter 12: Data Analysis and Visualization with R and Python in Excel – A Case Study Index Other Books You May Enjoy

Time series forecasting with deep learning – LSTM

This section will give you insights into advanced time series forecasting techniques using deep learning models. Whether you’re working with traditional time series data or more complex, high-dimensional data, these deep learning models can help you make more accurate predictions. In particular, we will cover the Long Short-Term Memory (LSTM) method using keras.

We will be using keras with a tensorflow backend, so you need to install both libraries:

  1. As always, let’s load the necessary libraries and preprocess some time series data:
    import numpy as np
    import pandas as pd
    import matplotlib.pyplot as plt
    from keras.models import Sequential
    from keras.layers import LSTM, Dense
    from sklearn.preprocessing import MinMaxScaler
    # Load the time series data (replace with your data)
    time_series_data = pd.read_excel('time_series_data.xlsx')
    # Normalize the data to be in the range [0, 1]
    scaler = MinMaxScaler...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}