• Home
• How To
• AskOTG
• Tutorials
• Certifications
• Contact Us

How-To Articles

• MOST RECENT
• MOST POPULAR

• Writing data from a Pandas Dataframe to a MySQL table

  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.

• Installing and configuring Elastic stack on Ubuntu

  Elastic Stack consists of Elasticsearch, Kibana, Beats and Logstash. In this artilce you will learn how to install and configure ELK stack on Ubuntu.

• Selecting, Slicing and Filtering data in a Pandas DataFrame

  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.

• Different ways to create a Pandas DataFrame

  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 know your Wordpress site is hacked and how to fix it

  How to identify that your Wordpress site is hacked? Once you know it is hacked, how do you clean/fix it?

• Handling Duplicate Rows in a Pandas Dataframe

  This tutorial shows you how to find and drop duplicate rows in a Pandas dataframe. Explains duplicated and drop_duplicates function with examples.

• Essential Git Commands Cheatsheet

  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.

• How to select random records from a database

  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.

• How to setup a FTP server on Windows 10

  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.

• Creating local user accounts in Windows 10

  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

• Changing user accounts in Windows 10

  How to change user account names in Windows 10 using Advanced User Accounts (Netplwiz) and from control panel.

• How to get the display settings right on Raspberry Pi

  How to get the TV/Monitor display resolution right on Raspberry pi running Raspbian

• Auto Login and Auto Start in Raspberry Pi

  How to automatically login to Raspberry Pi, how to run a script at startup and how to automatically start the desktop in Raspberry Pi

• Change network type from Public to Private in Windows 10

  How to change a network location from Public to Private or Private to Public in Windows 10 in a few easy steps

• How to check Fibre Channel HBAs in Linux

  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.

• C program to count lines, words and characters in a file

  This is a C program to count the number of lines, words and characters in a file

• Using .htaccess to restrict access to Files and Directories

  Restrict access to files and directories using .htaccess. Disable directory browsing and prevent access to certain files or filetypes

• How to install Whatsapp on your Wifi only Android Tablet

  How to install WhatsApp on WiFi only Tablets and how to use whatsapp web client to mirror your conversations on phone and pc.

• Set PATH and other environment variables in Windows 10

  How to set PATH variable and other SYSTEM and USER environment variables in Windows 10 from Advanced System Settings and also from Command line,

• How to add a Favourite Icon to your website

  Learn how to add a favicon or shortcut icon to your website.

See More → Sponsored

• Best Effective Ways to Write My Assignment with Ease

  Simple tips that have proven to be more than effective in practise when it comes to writing assignments.

• Ten things to consider when choosing a hosting provider

  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.

• How to search within Java,C++,PHP and other projects

  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.

• Setup your online store in less than 30 minutes

  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!!

• Publish your article here

Copyright 2020 Open Tech Guides. All rights reserved