Skip to main content

A look at Google Colaboratory (While Building a Stock Portfolio)

 

 

Google Colaboraotory with Python by Tech Enthusiast Morgan Lucas

After the group effort heard 'round the world in 2021, stocks are on everyone's minds. I didn't have money in GameStop, but I did have money in AMC from 2020.

I bought it right as most theaters were closing from the Coronavirus pandemic and it was extremely cheap.  

Why? I like the moviegoing experience! As of March 6th 2021, many AMC Theaters in New York City and State are reopening at 25% capacity.

I'm still holding onto the stock - It never rose as high as GameStop's - but you won't see me at any theaters so soon.

Onto today's topic: Google Colaboratory is a cool tool, allowing you to run Python scripts right in the browser.  You can even install things into the environment! Is it a little container environment running my program? 

 

Here is the video, by Computer Science. And here is a video of me giving a brief look. It sends you right back here.

('Colaboratory' is a portmanteau of Collaborate and Laboratory. I love portmanteau names! 😊)

The video creator has the data they used behind a paywall (Understandable). I found another dataset here on Kaggle (which I'd never thought I'd use again).  A lot of the data has the same values with different names. 

If anyone has better data somewhere with actual variety, I'm happy to try it again.

I also branched out and made copies using various past data of companies from NASDAQ (Thank you to the multiple people who pointed me in that direction).

I changed the Index to the Symbol of the organization on NYSE. 

Think:

  • DIS 
  • SNE
  • MSFT
  • EBAY

Then removed it from the chart with drop - It was there under both "CQS Symbol" and "NASDAQ Symbol". Both were removed with the same line for code economy.


The code at 10:33 in the video doesn't work in mine:

faulty python code


Remember; This is not the same dataset as in the video, so the data doesn't correlate. I remove the troublesome (df) at the end of both commands and it works without them. I'm more interested in learning the tool and knowing the logic right now.

 

There is a code snippet library on the left - Everything from where to pull data from to visualizing scatterplots.

 


 

scatterplot of python data


I really enjoy the Colaboratory. Being able to run snippets of code at a time without commenting out everything has helped me to understand Python better. The issue is having to rerun some previous commands to make sure everything is defined.

Comments

Popular posts from this blog

Making KPI Dashboards with PowerBI

 While this is the free tier, I cannot share or collaborate with others, nor can I publish content to other people's workspaces, but they will not stop me from screenshooting and recording these self-taught adventures,so! I'm doing this because I idly searched "Mattel careers" and "Information Technology", and seeing a bulletpoint saying the following: Analytical and reporting skills such as creating dashboards and establishing KPIs such as experience with PowerBI, Cognos, Tableau, and Google Data Lake/AWS is preferred And thought "Well, I've used Tableau, and I've heard about PowerBI,  even if its in-demandness is questionable , so how similar is it? And can I write about it?"  First, PowerBI (PIB) does have a downloadable, local version, but apparently Windows-only. I could download the .exe but I couldn't run it / drag it to applications on my MacBook.  Not a problem, we'll use the online SaaS version, and a dataset found here, ...

Log Sorting with AWS CloudWatch, AWS CloudWatch Insights

 The cool thing is, I was contracted to make these videos in collaboration with CloudAvail Technology Consulting to help people decide which service they wanted to use for their logging - AWS CloudWatch, AWS CloudWatch Insights, DataDog, or New Relic. I'm searching through nginx logs. I have accompanying videos of each service that you can find on the CloudAvail Youtube page; See these links to go to the DataDog and NewRelic posts.   The idea was to be subjective in the videos, but I can be objective on my personal blog.     CloudWatch     The syntax is odd, but easy to grasp. Sort log data by IP addresses, message codes, and status codes. The simplest query system, but not quite robust.   Insights       The syntax has changed - Vastly. I see major SQL influences. You can see that in how the parse function works - in this case, it's often taken pieces of a pre-existing standard - in this case, message - and breaking them into their own c...

Connecting IoT Devices to a Registration Server (Packet Tracer, Cisco)

 If you're seeing this post, I'm helping you, and you probably have LI presence: React and share this post to help me in return.   In Packet Tracer, a demo software made by Cisco Systems. It certainly has changed a lot since 2016. It's almost an Olympic feat to even get started with it now, but it does look snazzy. This is for the new CCNA, that integrates, among other things, IoT and Automation, which I've worked on here before. Instructions here . I don't know if this is an aspect of "Let's make sure people are paying attention and not simply following blindly", or an oversight - The instructions indicate a Meraki Server, when a regular one is the working option here. I have to enable the IoT service on this server. Also, we assign the server an IPv4 address from a DHCP pool instead of giving it a static one. For something that handles our IoT business, perhaps that's safer; Getting a new IPv4 address every week or so is a minimal step against an...