Michael D'Argenio mjdargen

## sheets_import.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                mjdargen
                / sheets_import.md
            
            
              Last active
              September 16, 2023 13:10
            
          
    Pull Google Sheet Data into Python

Shows how to use pull data from a Google Sheet into Python without the use of an API.
Publishing Google Sheet


Go to "File -> Publish to the web"
This will bring up the window shown below. Select the "Link" tab.
Select the specific page that you want to publish.
Then select to publish it as "Comma-separated values (.csv)"
Once you are ready, click Publish. A pop-up will appear asking if you are sure. Click "OK".


## get_haiku.py
import os
import re
import random
import requests
from nltk import word_tokenize
from nltk import pos_tag
from nltk.tokenize import SyllableTokenizer
from random_word import RandomWords

rw = RandomWords()

## nate_button.html
<!DOCTYPE html>
<html lang="en">

<head>
    <title>Nate Example</title>
    <meta charset="utf-8">
    <style>
        button>span {
            display: none;
        }

## anagrams.py
from random import choice
import os

with open("./bilingual/anagrams.txt", "r") as f:
    words = f.read().splitlines()

word = choice(words)
while len(word) < 4 or len(word) > 6:
    word = choice(words)
words.remove(word)

## webdev_zip_grader.py
# 1. Download the submissions.zip file from Canvas.
# 2. Place it in an empty folder for the specific assignment. Make sure it is called submissions.zip.
# 3. Copy the webdev_zip_grader.py script into the folder.
# 4. Make sure the folder is empty except for webdev_zip_grader.py and submissions.zip because it will delete everything else.
# 5. Double-click the script to run.
# 6. Hit the enter key in the script window to advance it to the next page.


import os
import shutil

## zipit.py
import os
import shutil
from zipfile import ZipFile

def main():

    # remove everything
    for root, subdirs, _files in os.walk(os.getcwd()):
        for d in subdirs:
            shutil.rmtree(os.path.join(os.getcwd(), d))

## install_ffmpeg.sh
#!/usr/bin/env bash

# Copied from sparrc: https://gist.github.com/sparrc/026ed9958502072dda749ba4e5879ee3

# Installs ffmpeg from source (HEAD) with libaom and libx265, as well as a few
# other common libraries
# binary will be at ~/bin/ffmpeg

sudo apt update && sudo apt upgrade -y

## spotipy_starter.py
import os
import spotipy
from spotipy.oauth2 import SpotifyClientCredentials
from dotenv import load_dotenv
load_dotenv()

artist = 'Taylor Swift'

# load credentials
credentials = SpotifyClientCredentials(

## nc_ftc_scouting.py
import os
import requests
import pandas as pd
from bs4 import BeautifulSoup as bs

DIR_PATH = os.path.dirname(os.path.realpath(__file__))


# retrieve soup for a page
def retrieve_soup(url):

## ospd.txt
aa
aah
aahed
aahing
aahs
aal
aalii
aaliis
aals
aardvark
	import os
	import re
	import random
	import requests
	from nltk import word_tokenize
	from nltk import pos_tag
	from nltk.tokenize import SyllableTokenizer
	from random_word import RandomWords

	rw = RandomWords()
	<!DOCTYPE html>
	<html lang="en">

	<head>
	<title>Nate Example</title>
	<meta charset="utf-8">
	<style>
	button>span {
	display: none;
	}
	from random import choice
	import os

	with open("./bilingual/anagrams.txt", "r") as f:
	words = f.read().splitlines()

	word = choice(words)
	while len(word) < 4 or len(word) > 6:
	word = choice(words)
	words.remove(word)
	# 1. Download the submissions.zip file from Canvas.
	# 2. Place it in an empty folder for the specific assignment. Make sure it is called submissions.zip.
	# 3. Copy the webdev_zip_grader.py script into the folder.
	# 4. Make sure the folder is empty except for webdev_zip_grader.py and submissions.zip because it will delete everything else.
	# 5. Double-click the script to run.
	# 6. Hit the enter key in the script window to advance it to the next page.


	import os
	import shutil
	import os
	import shutil
	from zipfile import ZipFile

	def main():

	# remove everything
	for root, subdirs, _files in os.walk(os.getcwd()):
	for d in subdirs:
	shutil.rmtree(os.path.join(os.getcwd(), d))
	#!/usr/bin/env bash

	# Copied from sparrc: https://gist.github.com/sparrc/026ed9958502072dda749ba4e5879ee3

	# Installs ffmpeg from source (HEAD) with libaom and libx265, as well as a few
	# other common libraries
	# binary will be at ~/bin/ffmpeg

	sudo apt update && sudo apt upgrade -y
	import os
	import spotipy
	from spotipy.oauth2 import SpotifyClientCredentials
	from dotenv import load_dotenv
	load_dotenv()

	artist = 'Taylor Swift'

	# load credentials
	credentials = SpotifyClientCredentials(
	import os
	import requests
	import pandas as pd
	from bs4 import BeautifulSoup as bs

	DIR_PATH = os.path.dirname(os.path.realpath(__file__))


	# retrieve soup for a page
	def retrieve_soup(url):