This article shows you how to write the data in a Pandas DataFrame to a MySQL table using the to_sql() function and SQLAlchemy toolkit.
Elastic Stack consists of Elasticsearch, Kibana, Beats and Logstash. In this artilce you will learn how to install and configure ELK stack on Ubuntu.
This article demonstrates how to select, subset and slice, index a Pandas DataFrame by row and column labels, by index position and using boolean conditions.
This tutorial shows you how to create a Pandas DataFrame from Python lists, dictionary, NumPy array, CSV and also to create empty dataframes.
How to identify that your Wordpress site is hacked? Once you know it is hacked, how do you clean/fix it?
This tutorial shows you how to find and drop duplicate rows in a Pandas dataframe. Explains duplicated and drop_duplicates function with examples.
Git is an open source version control system to track, share, organize and collaborate. This cheat sheet contains most commonly used git commands with some examples.
Learn how to select random rows from a database table in MySQL, Oracle and MS SQL Server. Also learn how to retrieve random documents from a MongoDB collection.
FTP server enables the transfer of file between computers. This article describes how to install and configure a FTP server on a Windows 10 machine.
This article describes how to add a local user account in Windows 10 without a Microsoft account or email id. Local user accounts can be administrator account or standard account
How to change user account names in Windows 10 using Advanced User Accounts (Netplwiz) and from control panel.
How to get the TV/Monitor display resolution right on Raspberry pi running Raspbian
How to automatically login to Raspberry Pi, how to run a script at startup and how to automatically start the desktop in Raspberry Pi
How to change a network location from Public to Private or Private to Public in Windows 10 in a few easy steps
Step by step guide on how to check FC HBAs are installed correctly to get the HBA card details like number of ports, WWN, type, status etc.
This is a C program to count the number of lines, words and characters in a file
Restrict access to files and directories using .htaccess. Disable directory browsing and prevent access to certain files or filetypes
How to install WhatsApp on WiFi only Tablets and how to use whatsapp web client to mirror your conversations on phone and pc.
How to set PATH variable and other SYSTEM and USER environment variables in Windows 10 from Advanced System Settings and also from Command line,
Learn how to add a favicon or shortcut icon to your website.
Simple tips that have proven to be more than effective in practise when it comes to writing assignments.
There are several factors to consider while choosing a web hosting provider for your website or E-commerce store. Lets look at some of the key elements among them.
Tools such as Notepad++, Windows Explorer and SeekFast enables users to search for text in text-based files without opening each result in a text editor.
Step by Step guide to setting up your own online shop in less than 30 minutes using shopify. It is really quick and easy. No payments or credit cards required!!