Thomas Mukei

## submit.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Mukei
                / submit.md
            
            
              Created
              June 13, 2022 14:27
                — forked from tanaikech/submit.md
            
              
                Downloading Shared Files on Google Drive Using Curl
              
          
    Downloading Shared Files on Google Drive Using Curl

When the shared files on Google Drive is downloaded, it is necessary to change the download method by the file size. The boundary of file size when the method is changed is about 40MB.
File size < 40MB

CURL

filename="### filename ###"
fileid="### file ID ###"
curl -L -o ${filename} "https://drive.google.com/uc?export=download&amp;id=${fileid}"

  
## gcloud_cheat_sheet.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Mukei
                / gcloud_cheat_sheet.md
            
            
              Created
              December 17, 2019 06:07
                — forked from pydevops/gcloud-cheat-sheet.md
            
              
                gcp gcloud cheat sheet
              
          
    Table of Contents


References
Other cheatsheets
multiple gcloud config configurations

switch gcloud context with gcloud config


auth
info
projects
zones


## install_packages.sh
#
#  Original solution via StackOverflow:
#    http://stackoverflow.com/questions/35802939/install-only-available-packages-using-conda-install-yes-file-requirements-t
#

#
#  Install via `conda` directly.
#  This will fail to install all
#  dependencies. If one fails,
#  all dependencies will fail to install.

## useful_pandas_snippets.py
# List unique values in a DataFrame column
# h/t @makmanalp for the updated syntax!
df['Column Name'].unique()

# Convert Series datatype to numeric (will error if column has non-numeric values)
# h/t @makmanalp
pd.to_numeric(df['Column Name'])

# Convert Series datatype to numeric, changing non-numeric values to NaN
# h/t @makmanalp for the updated syntax!

## amazon-csv.js
//Amazonの注文履歴をCSV形式にして出力するスクリプト
//
//以下のスクリプトを参考に作成されました。
//http://moroya.hatenablog.jp/entry/2013/06/03/225935
//
//CSVに成型しているのは14行目から定義されているformatEntryという関数なので、これを書き換えれば自由な書式で出力できます。
(function(){

	// 各注文履歴をCSVフォーマットにして返す
	var datePattern = new RegExp("(\\d{4})年(\\d{1,2})月(\\d{1,2})日");
	#
	# Original solution via StackOverflow:
	# http://stackoverflow.com/questions/35802939/install-only-available-packages-using-conda-install-yes-file-requirements-t
	#

	#
	# Install via `conda` directly.
	# This will fail to install all
	# dependencies. If one fails,
	# all dependencies will fail to install.
	# List unique values in a DataFrame column
	# h/t @makmanalp for the updated syntax!
	df['Column Name'].unique()

	# Convert Series datatype to numeric (will error if column has non-numeric values)
	# h/t @makmanalp
	pd.to_numeric(df['Column Name'])

	# Convert Series datatype to numeric, changing non-numeric values to NaN
	# h/t @makmanalp for the updated syntax!
	//Amazonの注文履歴をCSV形式にして出力するスクリプト
	//
	//以下のスクリプトを参考に作成されました。
	//http://moroya.hatenablog.jp/entry/2013/06/03/225935
	//
	//CSVに成型しているのは14行目から定義されているformatEntryという関数なので、これを書き換えれば自由な書式で出力できます。
	(function(){

	// 各注文履歴をCSVフォーマットにして返す
	var datePattern = new RegExp("(\\d{4})年(\\d{1,2})月(\\d{1,2})日");