hgascon

## Tasks by Date - for Obsidian and Dataview.js
```dataviewjs
// find dates based on format [[YYYY-MM-DD]]
const findDated = (task)=>{
 if( !task.completed ) {
  task.link = " " + "[[" + task.path + "|*]]";
  task.date="";
  const found = task.text.match(/\[\[([12]\d{3}-(0[1-9]|1[0-2])-(0[1-9]|[12]\d|3[01]))\]\]/);
  if(found) task.date = moment(found[1]);
  return true;
 }

## safari-history
sqlite3 /Users/alex/Library/Safari/History.db "select datetime(visit_time + 978307200, 'unixepoch', 'localtime') as date, title from history_visits order by visit_time asc"

## useful_snippets.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                hgascon
                / useful_snippets.md
            
            
              Created
              January 28, 2021 13:12
                — forked from drorata/useful_snippets.md
            
              
                Useful snippets
              
          
Ansible

AWS and boto3

Change tags of AWS-Glue crawler


Athena

Create partitioned external table

Assumptions
Create the table
Fix the table
Query the table


Docker


## useful_pandas_snippets.py
# List unique values in a DataFrame column
pd.unique(df.column_name.ravel())

# Convert Series datatype to numeric, getting rid of any non-numeric values
df['col'] = df['col'].astype(str).convert_objects(convert_numeric=True)

# Grab DataFrame rows where column has certain values
valuelist = ['value1', 'value2', 'value3']
df = df[df.column.isin(valuelist)]
	```dataviewjs
	// find dates based on format [[YYYY-MM-DD]]
	const findDated = (task)=>{
	if( !task.completed ) {
	task.link = " " + "[[" + task.path + "\|*]]";
	task.date="";
	const found = task.text.match(/\[\[([12]\d{3}-(0[1-9]\|1[0-2])-(0[1-9]\|[12]\d\|3[01]))\]\]/);
	if(found) task.date = moment(found[1]);
	return true;
	}
	# List unique values in a DataFrame column
	pd.unique(df.column_name.ravel())

	# Convert Series datatype to numeric, getting rid of any non-numeric values
	df['col'] = df['col'].astype(str).convert_objects(convert_numeric=True)

	# Grab DataFrame rows where column has certain values
	valuelist = ['value1', 'value2', 'value3']
	df = df[df.column.isin(valuelist)]