Yixuan ZhouUnivariate Stock Open Price prediction with LSTMIn this tutorial, we predict the stock prices along with changing times, and the LSTM model is used. We chose the open price for…Feb 15, 20211Feb 15, 20211
Yixuan ZhouSQLAlchemy: Hierarchical Tables and Handling Large ResultSetsThere are tables that join with themselves, we call these tables self-referential or hierarchical tables.Sep 11, 2020Sep 11, 2020
Yixuan ZhouSQLAlchemy: Calculating and Joining TablesCalculating values in a querySep 11, 2020Sep 11, 2020
Yixuan ZhouSQLAlchemy and Pandas for VisualizationDataFrame can take a SQLAlchemy ResultSetSep 10, 2020Sep 10, 2020
Yixuan ZhouSQLAlchemy: Applying Filtering, Ordering and Grouping to QueriesIn this chapter, you will write queries that allow you to filter, order, and count your data. All within the Pythonic framework provided…Sep 10, 2020Sep 10, 2020
Yixuan ZhouRelational Databases and SQLAlchemySQLAlchemy allows us to generate SQL queries by writing Python code. There are many different types of databases, and each database type…Sep 8, 2020Sep 8, 2020
Yixuan ZhouPower BI Project: UCI Credit Card Defaults in Taiwan 2005The dataset we’re working with comes from UCI Machine Learning Repository and this is a data set of credit card defaults that happened in…Sep 7, 2020Sep 7, 2020
Yixuan ZhouFront End Web Development (HTML, CSS, JavaScript)-Part 11. Open the terminal and create a new folder in the local user’s pathSep 4, 2020Sep 4, 2020
Yixuan ZhouBest Time to Buy and Sell StockSay you have an array for which the ith element is the price of a given stock on day i.Aug 12, 2020Aug 12, 2020