chaseedge

Lecture 1: Introduction to Research — [📝Lecture Notebooks] [▶️Video]
Lecture 2: Introduction to Python — [📝Lecture Notebooks] [▶️Video]
Lecture 3: Introduction to NumPy — [📝Lecture Notebooks] [▶️Video]
Lecture 4: Introduction to pandas — [📝Lecture Notebooks] [▶️Video]
Lecture 5: Plotting Data — [📝Lecture Notebooks] [[▶️Vide

chaseedge

function getImportData() {
  var ss = SpreadsheetApp.getActive();
  var sheet = ss.getSheetByName("input");
  if (sheet == null) {
      sheet = ss.insertSheet("input");
  }
  sheet.clear();

  sheet.getRange(1, 1).setValue("Date Scraped");
  sheet.getRange(1, 2).setValue("=IMPORTHTML(\"https://www.dmr.nd.gov/oilgas/riglist.asp\",\"table\",3)");

chaseedge

var outputSheet = ss.getSheetByName("output");
if (outputSheet == null) {
    outputSheet = ss.insertSheet("output");
}

if (outputSheet.getLastRow() == 0) {
    var i = 0;
} else {
    var i = 1;
}