SoftHints - Python, Pandas, Linux, SQL

Python
Python dependency error modules has requirement which is incompatible.
Python 3 SyntaxError: invalid syntax f strings
Python NameError: name 'self' is not defined
Python SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
Python index ValueError: substring not found
How to solve ImportError: No module named pip in Python
Python convert object to JSON 3 examples
python extract text from image or pdf
Python JSON tutorial for beginners
How to Transpose CSV/text File Python
How to request JIRA API with Python examples
Python 3 How to convert date to Unix timestamp
Python: How to protect PDF file with password PyPDF2
Python convert normal JSON to JSON separated lines 3 examples
How to merge multiple CSV files with Python
How to Search and Replace in Excel File using Python
How to Execute a String Containing Code in Python
Python 3 Examples How to Split String into List
Python 3 How to Shuffle List Examples
Python json to list and json to dict examples
python string split by separator
Python test performance and measure time elapsed in seconds
Python how to pretty print data - JSON, XML, dict
Python Multiline Comments Or How To Comment Multiple Lines
How to get first/last N elements of dictionary in Python
Python how to print pretty table from dictionary or list
Python string find, like and contains examples
Python change current directory(up to parent) 3 Examples
Python declare multiple variables
Python 3 compare two dictionary keys and values
Python 3 How to Subtract Time
Python count items in list

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

Linux Mint
Install latest NVIDIA drivers for Linux Mint 19/Ubuntu 18.04
Linux Mint identify, fix sound problems, set default device
Linux Mint 19 solutions for sound and video problems
HDMI/DP Monitor no signal but recognized Linux Mint 19
Linux Mint 19 How to disable "login keyring" and Chrome
Linux Mint: Low disk space on Boot
Screen flicker and tearing Linux Mint Cinnamon
Linux Mint - Cannot Login (login loop)
Linux Mint Recovery Mode or Advanced Boot Options
Where is the Trash Location in Linux Mint
5 Ways To Quickly Launch Programs On Linux Mint
How to Create a Bootable Windows 10 USB in Linux Mint
Linux Mint: How to Check Cron Logs (crontab -e)
7+ Steps To Clean Space On Linux Mint
How to Merge multiple CSV Files in Linux Mint
How to Completely Remove Flatpak - Linux Mint
How to Recover a Deleted File on Linux Mint or Ubuntu
Linux Mint 18 - How to add Desktop shortcut
Linux Mint 19 change languages with shortcut
Linux Mint 19 How to edit Main Menu
Simple ways to create shortcut in Linux Mint 19
Linux Mint 19 Add Shortcuts to Panel
Linux Mint 19 How to change user password
Linux Mint add Google Calendar on your desktop
Split screen, move windows and maximize on Linux mint/Ubuntu

Data Base
How to Export ER Diagram from MySQL
MySQL Equivalent of Oracle's SQL loader
How to import CSV file into MySQL 3 examples
Python read, validate and import CSV/JSON file to MySQL
Python 3 convert dictionary to SQL insert
Insert multiple rows at once with Python and MySQL
How to Convert MySQL Table to Pandas DataFrame / Python Dictionary
SQL Count not null values in every table column
MySQL How to find highest and lowest value
Group by and string concatenation in Oracle and MySQL
mysql select N max values per group
MySQL select min and max length of all table columns
Count words and phrases in a column MySQL/SQL
MySQL 8 how to select day, month and year from date
MySQL how to split and/or transform a string
Ubuntu 18.04 How to Install, Reinstall and Uninstall MySQL
How to rename MySQL schema - the proper way
Remote Connection to MySQL with SSH tunnel to Ubuntu 16
MySQL: VARCHAR or TEXT for long text fields
How To Install MySQL 8 on Ubuntu 16.04
MySQL convert column to row unpivot example
MySQL 8 Set or reset user password
MySQL Workbench 8 unsupported operating system for Linux Mint
How to reset user password Ghost 2 blog MySQL
MySQL 8 Access denied for user 'root'@'localhost'
How To Create a New User and Grant Permissions in MySQL
How to Easily Backup MySQL Database

jupyter
How to create Jupyter Notebook in PyCharm
IPython/Jupyter Notebook tricks for advanced in 2019
How to Display Two Pandas Dataframes side by side in Jupyter Notebook
How to Turn off Warnings in JupyterLab(Jupyter Notebook)
Python and Jupyter save and download CSV file
Jupyter/iPython Notebook download files as CSV, zip
How to Open JupyterLab Notebook Without the Output
How to Set and List Environmental Variable in Jupyter Notebook
How to increase cell width of Jupyter Notebook
Ubuntu 18 how to install Jupyter Notebook/IPython
6 ways to Recover deleted Jupyter Notebook (including JupyterLab)
How to Delete All/Markdown Cell in Jupyter/JupyterLab
JupyterLab Select, Move and/or Merge Multiple Cells

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

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

Applications
Ubuntu Linux add VirtualBox Guest Additions
Ubuntu Server VM: not working copy paste
How to Install VMware Player 14 on Ubuntu 18
How To Install VMware Player on Ubuntu 18.04/ Mint 19
Create virtual machine with VMware player 15 Linux Mint/Windows
Play Fortnite on Linux with virtual machine
VirtualBox black or blank screen issues Ubuntu/Linux Mint
Ubuntu 16.04 Server Install headless Google Chrome
How to install OpenJDK 9 on Ubuntu 16
Completely Uninstall Google Chrome or Chromium in Linux Mint
Ubuntu 18 how to install latest python 3.7 and list all python versions
Install Wine on Linux Mint 19 and add it to menu
How to Install Oracle JDK in Ubuntu 18 in 2020
How to Install Chromium on Linux Mint
How to Install WoeUSB in Linux Mint
How to Install Microsoft Teams on Linux Mint
How to Install Visual Studio Code on Linux Mint
How To Install Node.js on Linux Mint
