| """Functions for working with remote files using pandas and paramiko (SFTP/SSH).""" | |
| import pandas as pd | |
| import paramiko | |
| def read_csv_sftp(hostname: str, username: str, remotepath: str, *args, **kwargs) -> pd.DataFrame: | |
| """ | |
| Read a file from a remote host using SFTP over SSH. | |
| Args: |
People
 :bowtie: |
😄 :smile: |
😆 :laughing: |
|---|---|---|
😊 :blush: |
😃 :smiley: |
:relaxed: |
😏 :smirk: |
😍 :heart_eyes: |
😘 :kissing_heart: |
😚 :kissing_closed_eyes: |
😳 :flushed: |
😌 :relieved: |
😆 :satisfied: |
😁 :grin: |
😉 :wink: |
😜 :stuck_out_tongue_winking_eye: |
😝 :stuck_out_tongue_closed_eyes: |
😀 :grinning: |
😗 :kissing: |
😙 :kissing_smiling_eyes: |
😛 :stuck_out_tongue: |
| " URL: http://vim.wikia.com/wiki/Example_vimrc | |
| " Authors: http://vim.wikia.com/wiki/Vim_on_Freenode | |
| " Description: A minimal, but feature rich, example .vimrc. If you are a | |
| " newbie, basing your first .vimrc on this file is a good choice. | |
| " If you're a more advanced user, building your own .vimrc based | |
| " on this file is still a good idea. | |
| "------------------------------------------------------------ | |
| " Features {{{1 | |
| " |
| cartoon automatic | |
| set cartoon_loop_radius, 0.3 | |
| set cartoon_side_chain_helper, 1 | |
| set cartoon_discrete_colors, 1 | |
| bg_color white | |
| set ray_opaque_background, off | |
| set ray_texture, 5 | |
| set ray_shadows, 0 | |
| set antialias, 2 | |
| set ray_trace_mode, 1 |
| ### | |
| # WARNING! | |
| ### | |
| # Do you use .bashrc for configuration of your shell?? IF so, do this first: | |
| cat '[[ -s ~/.bashrc ]] && source ~/.bashrc' > ~/.bash_profile | |
| ### | |
| # Install homebrew | |
| ### | |
| ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)" |
| #Deactivate Startup Chime | |
| sudo nvram SystemAudioVolume=%80 | |
| #Activate Startup Chime | |
| sudo nvram -d SystemAudioVolume |
| # from: http://stackoverflow.com/a/73050/2806632 | |
| from operator import itemgetter | |
| l = [] # List of dictionaries | |
| k = '' # Key of interest to sort by | |
| # [..] fill list 'l' with dictionaries containing a 'k' key | |
| newlist = sorted(l, key=itemgetter(k), reverse=True) # reverse boolean for ascending/descending sort |
| first_letter = 'A' | |
| last_letter = 'Z' | |
| alphabet = list(map(chr, range(ord(first_letter), ord(last_letter) + 1))) |
| <div> | |
| <input | |
| type = "text" | |
| placeholder = "Something to say" | |
| ng-model = "target_variable" | |
| ng-pattern = 'pattern_variable' | |
| jb-on-enter = "executeCommand()" | |
| > | |
| </div> |
| find $1 -name '$2' -exec sed -i '$3' '{}' \; | |
| # WHERE: | |
| # $1 = folder | |
| # $2 = file pattern | |
| # $2 = substitution pattern (such as: s/\.src\./\./g ) |