bigquery-public-data.new_york_taxi_trips.tlc_yellow_trips_2017
Table size 12.79 GB
Number of rows 113,496,874
``SELECT total_amount, pickup_datetime, trip_distance
package gcfv2; | |
import java.io.BufferedWriter; | |
import com.google.gson.Gson; | |
import com.google.gson.JsonObject; | |
import java.io.BufferedReader; | |
import java.io.InputStreamReader; | |
import java.util.stream.Collectors; |
import datetime | |
import os | |
from google.cloud import logging | |
from typing import Mapping | |
import google.auth.transport.requests | |
import google.oauth2.id_token | |
import requests | |
import flask | |
gcloud functions deploy summarizeText \ | |
--gen2 \ | |
--runtime=python311 \ | |
--region=$GCP_REGION \ | |
--source=. \ | |
--entry-point=summarizeText \ | |
--trigger-http \ | |
--set-env-vars=GCP_PROJECT=$GCP_PROJECT,GCP_REGION=$GCP_REGION \ | |
--allow-unauthenticated |
import os | |
import json | |
import functions_framework | |
import google.cloud.logging | |
import vertexai | |
from vertexai.language_models import TextGenerationModel | |
PROJECT_ID = os.environ.get('GCP_PROJECT','-') |
const browser = await puppeteer.launch({args: ['--no-sandbox']}); | |
const page = await browser.newPage(); | |
await page.goto("https://loveiscomix.com/random"); | |
let imageurl = await page.evaluate(() => { | |
let item = document.querySelector('#primary > main > article > div > div.cellcomic > a > img'); | |
return 'https://loveiscomix.com/' + item.getAttribute('src'); | |
}) | |
browser.close(); |
let LoveIsComic_HTMLTemplate = ( | |
url | |
) => { | |
return ` | |
<!DOCTYPE html> | |
<html> | |
<head> | |
<title>Love Is Comic</title> | |
</head> | |
<body> |
function retrieveSentimentCF (line) { | |
var apiEndpoint = 'YOUR_CLOUDFUNCTIONS_HTTPS_ENDPOINT'; | |
var reviewData = { | |
review_text: line | |
}; | |
var cfCallOptions = { | |
method : 'post', | |
contentType: 'application/json', |
'use strict'; | |
const Language = require('@google-cloud/language'); | |
// Instantiates a client | |
const language = new Language.LanguageServiceClient(); | |
exports.analyzeSentiment = (req, res) => { | |
if (req.body.review_text == undefined) { | |
res.status(400).send("No review text provided"); |
function onOpen() { | |
var ui = SpreadsheetApp.getUi(); | |
ui.createMenu('Review Analysis Tools') | |
.addItem('Analyze Sentiment', 'analyzeSentiment') | |
.addToUi(); | |
} | |
function analyzeSentiment() { | |