convert a sqlite3 query result table into a pandas dataframe

The sqlite3 query returns a list of tuples. Here's a good way to convert the list of tuples into a pandas data frame.

def q():
    sql_c = " some query commands here"
    df = pd.DataFrame(dbc.execute(sql_c).fetchall())
   
    # get all column names
    cns = [d[0] for d in dbc.description]
    df.columns = cns

    return df

DataFrame create multiple new columns by applying a function that returns multiple

df[['sum', 'difference']] = df.apply(
    lambda row: add_subtract_list(row['a'], row['b']), axis=1)

vundle for vim plugin, use this one!

https://github.com/vim-scripts/vundle

5 available pane layouts when using tmuxp

tmuxp pane layout options:  

1. even-horizontal

2. even-vertical 

3. main-horizontal 

4. main-vertical

5. tiled

Add multiple columns to Pandas dataframe by applying a function that returns multiple values

df[['sum', 'difference']] = df.apply(
    lambda row: pd.Series(myfunc(row['a'], row['b'])), axis=1)

# The pd.Series is the key!

Bash | Print confirmation before exit

command 1
command 2
.
.
.

[ $? -eq '0' ] && echo "Job done!"
exit $?

Bash | remove a file is already exists

[ -e file ] && rm file