SSL expirations

👋 Welcome to Deepnote! Here is a short guide to get you started!

1. Execute a cell

Let's run the code cell below by selecting it and clicking Run in the right sidebar. You can also use the shortcut Shift+Enter to run it and move to the next cell.

import os import pandas_redshift as pr import matplotlib matplotlib.rcParams["figure.figsize"] = [12, 12] pr.connect_to_redshift(dbname = os.environ["PG_DBNAME"], host = os.environ["PG_HOST"], port = 5432, user = os.environ["PG_USER"], password = os.environ["PG_PASS"] )

df = pr.redshift_to_pandas(f""" select domains.id, domains.name, m.next_expiration_at as min_after, h.next_expiration_at as h_after, d.next_expiration_at as d3_after from scan_results m join scan_results h on m.domain_id = h.domain_id and h.stage = 'hour_after_exp' and h.type='ssl' join scan_results d on m.domain_id = d.domain_id and d.stage = '3days_after_exp' and h.type='ssl' join domains on domains.id = m.domain_id where m.type='ssl' and m.next_expiration_at between '2020-11-01' and '2020-11-20' and m.stage = 'minute_before_exp' and d.next_expiration_at > m.next_expiration_at """)

df['id'].plot.hist()

Your variables show up in the Variable explorer in the Files sidebar on the left. It's quite easy to lose track of all your variables and their values, and the Variable explorer comes in handy when that happens.

2. Collaborate 🤝

Do you know anyone who would also appreciate a new way to work with notebooks?

Invite them to Deepnote! Head to the Share menu and hit Manage collaborators to add them to this project.

Actually, why don't you try adding them right now, and collaborating on this project in real-time:

3. Access your data... ⬆️

In the Integrations sidebar tab, you can connect to your database, bucket or BigQuery. You can also upload files to a Shared dataset.
To upload your local data, head to the Files tab and hit Upload

4. Terminals 💻

Create new terminal in Terminal sidebar tab.
You have full control of your machine, including sudo access

5. Work efficiently

Moving from keyboard to mouse takes time, and we know learning 30 keyboard shortcuts is inefficient.
Press ⌘+P or Ctrl+P to open the Command palette and navigate to the notebook you rock.ipynb.

(Become a Deepnote Ninja, and do step 5. The tutorial continues there.)

Have a question? 🤔

Hit the question mark in the bottom left corner and chat with us! We're happy to help 👋

You can find answers to the most common questions in our docs at docs.deepnote.com
Don't forget to join our slack community!

SSL expirations

1. Execute a cell

2. Collaborate 🤝

3. Access your data... ⬆️

4. Terminals 💻

5. Work efficiently

Have a question? 🤔

Recommended on Deepnote

Stock Market Analysis

The 10 Best Ways to Create NumPy Arrays

Wide Residual Networks