SoftHints - Python, Pandas, Linux, SQL Tutorials and Guides

Python
What is Slicing in Python With Examples
How to Auto Generate requirements.txt (Dependencies) in Python - 3 examples
Python: List vs Tuple vs Dictionary vs Set
Python count items in list
How to Validate IP Address in Python
How to Execute a String Containing Code in Python
How to Search and Replace in Excel File using Python
How to merge multiple CSV files with Python
How to solve ImportError: No module named pip in Python
Python index ValueError: substring not found
Python SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
Python NameError: name 'self' is not defined

Pandas
How to Merge Multiple JSON Files Into Pandas DataFrame
How to Use Like Operator in Pandas DataFrame
Pandas TypeError: unhashable type: 'list'/'dict'
Pandas : Crosstab - cross tabulation of two (or more) factors - usage and examples
Pandas: How to filter results of value_counts?
Pandas - value_counts - multiple columns, all columns and bad data
Pandas compare columns in two DataFrames
How to Show All Columns, Rows and Values in Pandas
Pandas: Check If Value of Column Is Contained in Another Column in the Same Row
Pandas count and percentage by value for a column
Python Pandas How to Concatenate Two Columns
Python Pandas 7 examples of filters and lambda apply
text/CSV file to dataframe with Python and pandas
Pandas - Random Sample of a subset of a DataFrame - rows or columns
Pandas How to create DataFrame with Random Values N x M

Linux Mint
How to Disable Workspace Switching Sound in Linux Mint
Split screen, move windows and maximize on Linux mint/Ubuntu
Linux Mint add Google Calendar on your desktop
Linux Mint 19 How to change user password
How to Install Viber on Linux
How to Recover a Deleted File on Linux Mint or Ubuntu
How to Completely Remove Flatpak - Linux Mint
How to Merge multiple CSV Files in Linux Mint
How to Setup Printer and Fix Printing Problems in Linux Mint
How to Solve Random Freeze in Linux Mint
Where is the Trash Location in Linux Mint
Linux Mint Recovery Mode or Advanced Boot Options
HDMI/DP Monitor no signal but recognized Linux Mint 19
Linux Mint 19 solutions for sound and video problems
Linux Mint identify, fix sound problems, set default device
Install latest NVIDIA drivers for Linux Mint 19/Ubuntu 18.04
How to Write Script in Bash?
How to Calculate Two Variables in Bash
How to Solve "Invalid Arithmetic Operator" - Floating-point Math in Bash
How to Sleep Until a Specific Time/Date in Linux Bash

Data Base
How to Easily Backup MySQL Database
How To Create a New User and Grant Permissions in MySQL
MySQL 8 Access denied for user 'root'@'localhost'
How to reset user password Ghost 2 blog MySQL
MySQL how to split and/or transform a string
MySQL 8 how to select day, month and year from date
Count words and phrases in a column MySQL/SQL
MySQL select min and max length of all table columns
How to Convert MySQL Table to Pandas DataFrame / Python Dictionary
Insert multiple rows at once with Python and MySQL
Python 3 convert dictionary to SQL insert
Python read, validate and import CSV/JSON file to MySQL
How to import CSV file into MySQL 3 examples
MySQL Equivalent of Oracle's SQL loader
How to Export ER Diagram from MySQL

jupyter
How to Hide Sidebars, Navigation, Header in JupyterLab
Invalid Server Password in JupyterLab and Jupyter Notebook
How to Add/Run/Save Code from .py Into Jupyter Notebook Cell
JupyterLab Select, Move and/or Merge Multiple Cells
How to increase cell width of Jupyter Notebook
How to Set and List Environmental Variable in Python and Jupyter Notebook
How to Open JupyterLab Notebook Without the Output
Jupyter/iPython Notebook download files as CSV, zip
How to Turn off Warnings in JupyterLab(Jupyter Notebook)
How to Display Two Pandas Dataframes side by side in Jupyter Notebook
IPython/Jupyter Notebook tricks for advanced in 2019
How to create Jupyter Notebook in PyCharm

Regex
Use Regex To Remove lines containing word in Sublime
Sublime 3 Regex Search and Replace Examples
Sublime Text 3 tricks: compare files, highlight and regex
Notepad++ regex replace capture group examples list
How to Match text between two strings with regex in Python
Regex for Phone Number Find and Validation in Python
Python Regular Expression Matching Multiline Comments and Docstrings
Java regex match abbreviations 5 examples
How to Match Strings Not Starting With Pattern using Regex and Python
Regex to Match no space or one space in Python
python regex match examples

PyCharm
PyCharm How to restore deleted file
Run and debug Scrapy projects with PyCharm
PyCharm exclude folders from indexing, find and show usages
How to install Python 3.7 and setup PyCharm on Linux Mint 18/19
PyCharm how to delete a git branch locally and remotely
PyCharm Github Push failed: Repository not found
PyCharm/IntelliJ 18 change Git user
PyCharm Version Control and git complete tutorial for beginners
PyCharm virtualenv ModuleNotFoundError: No module named 'distutils.core'
No Python Interpreter Configured For The Module - PyCharm/IntelliJ
IntelliJ IDEA Error Loading Project: Cannot load facet Python
Intellij IDEA 2018 unable to resolve class
IntelliJ community edition add CSS and JSP syntax highlighting
Intellij open multiple projects or windows

Applications
how to install julia in linux mint
How to Convert PDF to ePUB with Linux
How To Install Node.js on Linux Mint
How to Install Visual Studio Code on Linux Mint
VirtualBox black or blank screen issues Ubuntu/Linux Mint
Play Fortnite on Linux with virtual machine
Create virtual machine with VMware player 15 Linux Mint/Windows
How To Install VMware Player on Ubuntu 18.04/ Mint 19
