AsthaSharma1’s gists

AsthaSharma1 / combinecsv.py

Created July 7, 2021 14:23

	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 ])

AsthaSharma1 / djQueue.html

Last active June 18, 2021 19:38

javascript code for a tutorial www.apispreadsheets.com/tutorials/custom-web-app-forms-login-update-delete.html

	<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{

AsthaSharma1 / loginForm.js

Last active June 23, 2021 17:17

login form javascript code for a tutorial www.apispreadsheets.com/tutorials/custom-web-app-forms-login-update-delete.html


	// 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"
	};

AsthaSharma1 / login.html

Last active June 23, 2021 17:17

login form code for a tutorial www.apispreadsheets.com/tutorials/custom-web-app-forms-login-update-delete.html

	<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');

AsthaSharma1 / display_fetch.js

Created May 25, 2021 21:36

	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 / 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 / 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 / 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 / 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 / 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{