Michele Pasin lambdamusic

## bard-input-test.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                lambdamusic
                / bard-input-test.md
            
            
              Last active
              November 28, 2023 20:24
            
              
                bard input test
              
          
    2023-11-28
https://console.cloud.google.com/vertex-ai/generative/language/prompt-examples/Financial%20table%20summarization?project=ds-data-solutions-gbq
You are a research analyst  and you are required to summarize the key insights of given numerical tables.


## 2023-07-04-notes-deep-work-the-book.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                lambdamusic
                / 2023-07-04-notes-deep-work-the-book.md
            
            
              Last active
              November 22, 2023 08:50
            
              
                notes-deep-work-2016
              
          
    Notes from Deep Work by Cal Newport

A very biased collection of quotes and ideas from the book Deep Work by Cal Newport (2016).
Concept map

flowchart LR
    A((Deep Work)) -->|Versus| B(Shallow Work)
    B --> B1[Shallow work promotes more shallow work]

  
## quote.md

      
              2 files
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                lambdamusic
                / quote.md
            
            
              Last active
              January 23, 2023 08:05
            
              
                test-quote
              
          
template: quote.html
title: "Additive manufacturing"
source: "A Third Industrial Revolution | The Economist"
url: http://www.economist.com/node/21552901
date: 2013-02-26
modified: 2015-05-04
review: false


## wdatebash
#!/bin/bash

wdate () {

    search=$1;

    zoneinfo=/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/pytz/zoneinfo/;
    format='%a %F %T';

    find -L $zoneinfo -type f \

## researchers.sql
-- Pub criteria:
--   FOR code
--   Specific journals
--   Year

-- Author criteria:
--   FCR (of any paper for last 5 years) > 1.5
--   Last publication < 24 months ago
--   Total publications > 7

## 1-introducing-datasets.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                lambdamusic
                / 1-introducing-datasets.ipynb
            
            
              Created
              November 30, 2020 17:48
            
              
                test.ipynb
              
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## arrays.sql

-- example 1
-- unnest an array in line so to perform an aggregation

select
  id,
  (SELECT MAX(e) from UNNEST(email) e) as first_email
from `dimensions-ai.data_analytics.researchers` r
WHERE ARRAY_LENGTH(email) > 0
LIMIT 10

## researchers1.sql
-- Return researchers and their publication count
--    LIMITED TO
--    publications with FOR “11 Medical and Health Sciences”
--    WHERE
--    Researcher is from Canada, Austria, Belgium, Czech Rep, Denmark, Finland, France, Australia
--    Researcher did NOT publish in the 2018, 2019, 2020 in a journal from publisher “Public Library of Science (PLoS)”
--    Researcher has email address
--    number of publications is minimum 3
--    sorted by
--    publication count

## covid19-tutorial-1.sql
SELECT
 p.id,
 p.title.preferred AS title,
 p.doi,
 p.year,
 p.journal.title,
 p.type,
 p.date AS date_publication,
 p.date_inserted,
FROM

## python_request_create_gist.py
'''
HTTP Reuests has following parameters:
1)Request URL
2)Header Fields
3)Parameter
4)Request body

PREREQUISITE
* head over to https://github.com/settings/tokens and generate a new token with 'gists' permissions
	#!/bin/bash

	wdate () {

	search=$1;

	zoneinfo=/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/pytz/zoneinfo/;
	format='%a %F %T';

	find -L $zoneinfo -type f \
	-- Pub criteria:
	-- FOR code
	-- Specific journals
	-- Year

	-- Author criteria:
	-- FCR (of any paper for last 5 years) > 1.5
	-- Last publication < 24 months ago
	-- Total publications > 7

	-- example 1
	-- unnest an array in line so to perform an aggregation

	select
	id,
	(SELECT MAX(e) from UNNEST(email) e) as first_email
	from `dimensions-ai.data_analytics.researchers` r
	WHERE ARRAY_LENGTH(email) > 0
	LIMIT 10
	-- Return researchers and their publication count
	-- LIMITED TO
	-- publications with FOR “11 Medical and Health Sciences”
	-- WHERE
	-- Researcher is from Canada, Austria, Belgium, Czech Rep, Denmark, Finland, France, Australia
	-- Researcher did NOT publish in the 2018, 2019, 2020 in a journal from publisher “Public Library of Science (PLoS)”
	-- Researcher has email address
	-- number of publications is minimum 3
	-- sorted by
	-- publication count
	SELECT
	p.id,
	p.title.preferred AS title,
	p.doi,
	p.year,
	p.journal.title,
	p.type,
	p.date AS date_publication,
	p.date_inserted,
	FROM
	'''
	HTTP Reuests has following parameters:
	1)Request URL
	2)Header Fields
	3)Parameter
	4)Request body

	PREREQUISITE
	* head over to https://github.com/settings/tokens and generate a new token with 'gists' permissions