Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Tkinter is a Python toolkit library used to build interfaces, design applications and create Graphical User Interfaces (GUIs). It originated from the Tcl programming language, which Python uses as a wrapper around Tk GUI Toolkit. Now it is used mostly with Python. It is a versatile tool where you can develop pages, buttons and customize fonts and background colours according to your preference. A file explorer is a tool that allows the user to navigate through all existing files present in the system for ease of access to files and open them without much difficulty. It offers a centralized database, ... Read More
Fidget Spinner is one of the fun and interesting projects that can be made possible using existing Python modules. A fidget spinner is a device that remains stationary in one place and keeps spinning as long as the person flicks it constantly, or else it will stop spinning completely. To simulate this, we can use libraries like pygame which provides us with an interface which can be customized to our liking while building games in general. There is also another such library which will be used for running the fidget spinner, similar to its real-life counterpart. Installation and Syntax To ... Read More
Selenium, an open source automation testing tool is used with other programming scripts like python , java , javascript and pearl to test web applications. It is widely used by developers for automation testing. Element Methods of Selenium 1. send_keys () − Used for setting up input text boxes which includes edit box, text area, fields inside forms and modifier keys. It extends properties from the keys class. Return Type − null 2. is_selected() − Checks if an element is selected or not by the user Return Type − boolean value ( True or False). 3. is_displayed() − Checks ... Read More
What is a JSON file?JSON stands for JavaScript Object Notation. It is commonly used for transmitting data in web applications (such as sending data from server to client to display on the web pages).Sample JSON FileExample 1: { "fruit": "Apple", "size": "Large", "color": "Red" }Example 2: { 'name': 'Karan', 'languages': ['English', 'French'] }The json file will have .json extensionRead JSON file in PythonPython has an in-built package called json which can be used to work with JSON data and to read JSON files. The json module has many functions among which load() and loads() are ... Read More
In this article, we will explain what are the compound datatypes and data structures in python. Variables have so far only stored one value. What if we wish to save many related values? We could simply create distinct variables for each. But what if we don't know how many values will be present? What if we wish to use these values within a loop? Compound data structures are data types that can store a large number of values. In Python, there are various types of compound data structures. We will mostly concentrate on Lists. In the end, we will ... Read More
This article is designed for user to group the time data by using the two examples for minutes, and hours. To understand the process in depth it is better to explain both the processes separately by using different example. Interval can be defined as the difference in between two provided time periods. For example, if first time is 2 o clock and another time is 4 o clock, then the interval between them is of 2 hours( if evaluated in terms of hours). Examples to Group Time by Hours in Excel Example 1 Step 1 First open the ... Read More
Grouping sheet in excel is a good feature. By using this feature users can use the data of multiple sheets simultaneously. This feature will save lots of user time. This feature allows users to properly structure the data with the header names mentioned in the column. Once, the user work of the grouped sheet is completed, then the user should need to ungroup the grouped sheets. This will help user to avoid confusion and ambiguities. Let’s go through the below-provided article to understand the use and application of grouped and ungrouped worksheets. Advantages of the Grouped Worksheet ... Read More
Grouping will save a lot of time when users need to perform the same task repeatedly. In more, simple word changes made to the single sheet will be reflected in multiple grouped sheets simultaneously. radio/ open buttons are a type of control buttons available in Excel. A group of multiple open/radio buttons can be created by using two form buttons and by using two ActiveX buttons. Both processes are based on almost based on same steps. But the second process will need a few extra steps to perform the same tasks. In short, it can be said that using the ... Read More
This article focusses about the evaluation of the first and last empty rows. To accomplish the provided task, it is better to use VBA code. VBA is an acronym for visual basic analysis. It is a Microsoft programming language used for office applications. It contains a coding script. Code can run like other front-end programming languages. Empty rows are those that do not contain any data but are available in the provided table structure. During this strategy user learn how to open the VBA editor, and steps to execute the defined module. Examples to go to Evaluate the First ... Read More
Nowadays, many tutorials and guides are available, to guide the user about the shortcut or easy ways to access the same work, in a shorter time. This will help user to save time and increases their processing speed. Similarly, this article will try to teach two methods to access specific sheets within excel. List of example strategies, we are going to use for this article: The first example, allows the user to switch the sheet directly. Second, an example guides the user about the strategy by using which ... Read More