SoftHints - Python, Pandas, Linux, SQL Tutorials and Guides
Python
If else in list comprehension Python
How do you make a Counter in Python?
How get parent directory from file path in 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 Send Multiple Concurrent Requests in Python
How to List Files and Directory Tree Structure in Python
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
Python convert normal JSON to JSON separated lines 3 examples
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
Python 3 SyntaxError: invalid syntax f strings
Python dependency error modules has requirement which is incompatible.
Pandas
How to Merge Multiple JSON Files with Python
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
Python read huge JSON file with Pandas
Python 3 ImportError: No module named 'pandas.core.indexes'
Python cumulative sum per group with pandas
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
Linux Mint 19 Add Shortcuts to Panel
Simple ways to create shortcut in Linux Mint 19
Linux Mint 19 How to edit Main Menu
How To Download Linux Mint Backgrounds
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
7+ Steps To Clean Space On Linux Mint
Linux Mint: How to Check Cron Logs (crontab -e)
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
Linux Mint - Cannot Login (login loop)
Screen flicker and tearing Linux Mint Cinnamon
Linux Mint: Low disk space on Boot
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 Pass, Modify and Pipe Output to Next Command in Bash
How to Replace Substring from String - Bash
bash random number in range
What are bash shell variables?
How to Add a New Line to the Output in Bash?
How to Save a cURL Output to a File?
Easily Convert JSON to JSON lines in Linux jq
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 Workbench 8 unsupported operating system for Linux Mint
MySQL 8 Set or reset user password
MySQL convert column to row unpivot example
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
mysql select N max values per group
Group by and string concatenation in Oracle and MySQL
MySQL How to find highest and lowest value
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 Delete All/Markdown Cell in Jupyter/JupyterLab
6 ways to Recover deleted Jupyter Notebook (including JupyterLab)
Ubuntu 18 how to install Jupyter Notebook/IPython
How to Automatically Create Jupyter Notebooks - Python + Nbformat
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
Python and Jupyter save and download CSV file
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
Notepad++ regex replace wildcard capture group
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
java regex matcher example
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
IntelliJ Debug, conditional breakpoints and step back
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
IntelliJ Idea Integrating with Bitbucket repository
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 Compare Files in Sublime Text 4
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
How to Install Microsoft Teams on Linux Mint
How to Install WoeUSB in 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
How to Install VMware Player 14 on Ubuntu 18
Ubuntu Server VM: not working copy paste
Ubuntu Linux add VirtualBox Guest Additions
