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

How-To Articles

• MOST RECENT
• MOST POPULAR

• 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

• Interacting with Jira using Python and REST API

  Developers can create scripts/programs using Python and Jira REST API to access resources such as projects, issues, comments, users etc., from Jira Cloud and Server Platforms.

• Restricting Management Access on Juniper SRX

  This article describes how to restrict management access on Juniper SRX device to specific network addresses by setting up a firewall filter

• 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.

• How to add a Favourite Icon to your website

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

• How to disable Telnet on Cisco Switches and Routers

  Telnet lets you manage Cisco switches and routers remotely however it is not very secure. This article explains how to disable Telnet on Cisco devices

See More → Sponsored

• 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 2019 Open Tech Guides. All rights reserved