Skip to content

Instantly share code, notes, and snippets.

import os
import glob
import pandas as pd
os.chdir("/mydir")
extension = 'csv'
all_filenames = [i for i in glob.glob('*.{}'.format(extension))]
#combine all files in the list
combined_csv = pd.concat([pd.read_csv(f) for f in all_filenames ])
<html>
<head>
<title> DJ Queue </title>
<script src="https://www.gstatic.com/firebasejs/8.6.3/firebase-app.js"></script>
<script src="https://www.gstatic.com/firebasejs/8.6.3/firebase-auth.js"></script>
<script src="loginForm.js"> </script>
</head>
<style>
@import url('https://fonts.googleapis.com/css2?family=Roboto&display=swap');
body{
// Your web app's Firebase configuration
var firebaseConfig = {
apiKey: "AIzaSyBAGCR7VhRhpCTbln069BS4WTFf0UQcbyk",
authDomain: "loginpage-dc3a1.firebaseapp.com",
projectId: "loginpage-dc3a1",
storageBucket: "loginpage-dc3a1.appspot.com",
messagingSenderId: "368995587873",
appId: "1:368995587873:web:9997247edef5f1b74f9060"
};
<html>
<head>
<title> Login Page </title>
<script src="https://www.gstatic.com/firebasejs/8.6.3/firebase-app.js"></script>
<script src="https://www.gstatic.com/firebasejs/8.6.3/firebase-auth.js"></script>
<script src="loginForm.js"> </script>
<style>
@import url('https://fonts.googleapis.com/css2?family=Roboto&display=swap');
fetch("https://api.apispreadsheets.com/data/12633/").then(res=>{
if (res.status === 200){
res.json().then(data=>{
const yourData = data["data"]
for(let i = 0; i < yourData.length; i++){
let rowInfo = yourData[i]
let rowInfoDiv = document.createElement("div")
rowInfoDiv.classList.add("song-row")
@AsthaSharma1
AsthaSharma1 / display.html
Last active May 28, 2021 13:06
HTML code for displaying data from a form, powered by www.apispreadsheets.com
<!DOCTYPE html>
<html>
<head>
<title> Music Queue </title>
</head>
<style>
@import url('https://fonts.googleapis.com/css2?family=Roboto&display=swap');
body{
background-color: purple;
height: 100%;
@AsthaSharma1
AsthaSharma1 / form.html
Last active May 28, 2021 12:53
Making an HTML form that's powered by APISpreadsheets.com
<!DOCTYPE html>
<html>
<head>
<title>DJ Song Form </title>
<script
src="https://code.jquery.com/jquery-3.4.1.js"
integrity="sha256-WpOohJOqMqqyKL9FccASB9O0KwACQJpFTUBLTYOVvVU="
crossorigin="anonymous"></script>
<script>
function SubForm (){
@AsthaSharma1
AsthaSharma1 / fetch.js
Created March 15, 2021 02:32
fetch part of script tag for dynamic text tutorial on www.apispreadsheets.com
fetch("https://api.apispreadsheets.com/data/9396/").then(res=>{
if (res.status === 200){
res.json().then(data=>{
const yourData = data["data"]
let rowInfo = yourData[0]
let rowInfoDiv = document.createElement("div")
rowInfoDiv.classList.add("elemsRow")
let rowWeek = document.createElement("p")
@AsthaSharma1
AsthaSharma1 / aboutme.js
Created March 15, 2021 02:27
FULL Javascript Code for Dynamic Text tutorial for www.heyastha.com
<script>
let allElemsElm = document.getElementById("allElems")
let errorMessageElm = document.getElementById("errorMessage")
function setErrorDisplay(){
allElemsElm.style.display ="none"
errorMessageElm.style.display = "block"
}
fetch("https://api.apispreadsheets.com/data/9396/").then(res=>{
@AsthaSharma1
AsthaSharma1 / about.html
Created March 15, 2021 02:04
Full About Me code for my personal website, www.heyastha.com for the dynamic text tutorial
<!DOCTYPE html>
<html>
<head>
<title> About Me </title>
<style>
@import url('https://fonts.googleapis.com/css2?family=Comfortaa:wght@500&display=swap');
body{
background-color: whitesmoke;
}
#about{