Skip to content
  • Facebook
  • GitHub
  • YouTube
  • Pinterest
My Tec Bits
  • Home
  • Microsoft
    • .Net
      • ASP.NET
      • MVC
      • Visual Studio
    • IIS
    • SQL Server
      • SQL Server 2019
      • SQL Server 2017
      • SQL Server 2016
      • SQL Server 2014
      • SQL Server 2012
      • SQL Server 2008
    • Windows OS
  • Web Development
    • Java Script
    • Jquery
    • Python
    • Bootstrap
    • Zurb Foundation
    • Web Security
  • More
    • macOS
    • Reviews
  • Online Tools
    • Fitness Calculators
    • Encoders & Decoders
    • Cryptography
    • Unit Converters
    • Math. Calculators
    • Date & Time Calculators
    • Finance Calculators

Beaulin Twinkle

How to calculate Mean, Median and Mode in Python?

Aug 3, 2022 by Beaulin Twinkle
calculate Mean, Median and Mode in Python

Here is the sample code for calculating mean, median and mode in Python programming language using its inbuilt statistics module.

Categories Python Tags Python 3.10.x, Python 3.x Leave a comment

How to calculate mode in C#?

Jul 29, 2022 by Beaulin Twinkle
Calculate Mode in C#

Here is the sample code to calculate mode in C# for a set of numbers in an array. This method will get you single mode or multi modes.

Categories .Net Tags .NET Framework, .NET Framework 4.8, C# (C Sharp), C# 7.0 (C Sharp) Leave a comment

How to calculate mean In C#?

Jul 21, 2022 by Beaulin Twinkle
Calculate mean In C#

It is easy to calculate mean in C#, as arithmetic mean is just the average of the collection of numbers. Here is the sample code.

Categories .Net Tags .NET Framework, .NET Framework 4.8, C# (C Sharp) Leave a comment

How to calculate median in C#?

Jul 20, 2022 by Beaulin Twinkle
Calculate median in C# with your own code

In this article we will see how to calculate median in c# .Net by coding the median algorithm by yourself and by using a 3rd party library.

Categories .Net Tags .NET Framework, .NET Framework 4.8, C# (C Sharp) Leave a comment

How to calculate statistical mode in SQL Server?

Jul 8, 2022 by Beaulin Twinkle
Get old the modes

Let us see with example on how to calculate the mathematical statistical mode in SQL Server.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How to calculate mean in SQL Server?

Jul 20, 2022Jun 9, 2022 by Beaulin Twinkle
calculate mean in SQL Server

Here you will see with a simple example on using an existing TSQL function to calculate the mean in SQL Server.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How to get execution time in milliseconds in SSMS?

May 28, 2022May 28, 2022 by Beaulin Twinkle
How to get execution time in milliseconds in SQL Server Management Studio?

One another simple method to get the execution time in milliseconds in SQL Server Management Studio (SSMS)

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How to find whether the string contains a substring in Python?

May 29, 2022May 13, 2022 by Beaulin Twinkle
How to find whether the string contains a substring in Python

There are couple of different ways to find whether the string contains a substring in Python program. Let us see them.

Categories Python Tags Python 3.10.x, Python 3.x, Visual Studio Code Leave a comment

Reading XML file with PHP

May 5, 2022 by Beaulin Twinkle
Reading XML File With PHP

Here I’ve used the SimpleXML XML manipulation function of PHP for reading XML file from PHP code.

Categories PHP Tags PHP 7.x, Visual Studio Code 1 Comment

How to launch a PHP website on macOS?

May 5, 2022May 5, 2022 by Beaulin Twinkle
Start the PHP server on macOS

A simple way to launch a PHP website on macOS using its in-built PHP server. This may not be a solution for someone to develop and debug PHP website.

Categories macOS, PHP Tags macOS Big Sur, PHP 7.x Leave a comment

How to import a JSON file to a variable in Python?

Apr 21, 2022 by Beaulin Twinkle
Import A JSON File To A Variable In Python

There are several packages available for Python to import JSON files. I prefer using the pandas. Here is an example to import a JSON file to a variable.

Categories Python Tags Python 3.10.x, Python 3.x, Python Tips, Visual Studio Code Leave a comment

How to import a CSV file to a variable in Python?

Apr 8, 2022 by Beaulin Twinkle
import a csv file to a variable in Python

There are several packages available for Python to import CSV files. I prefer using the pandas. Here is an example to import a csv file to a variable.

Categories Python Tags macOS Big Sur, Python 3.10.x, Python 3.x, Python Tips, Visual Studio Code Leave a comment

VirtualBox error NS_ERROR_FAILURE (0x80004005) on macOS

Aug 6, 2022Mar 24, 2022 by Beaulin Twinkle
VirtualBox Error NS_ERROR_FAILURE (0x80004005) On MacOS

Solution for VirtualBox error NS_ERROR_FAILURE (0x80004005) on macOS which won’t allow to launch the virtual machine after updating macOS.

Categories macOS Tags macOS Big Sur, VirtualBox, VirtualBox 6.1 Leave a comment

How to perform an IF…THEN operation in SQL SELECT statement?

Mar 18, 2022 by Beaulin Twinkle
IF…THEN Operation In SELECT Statement

Here we will see couple of methods to perform an IF…THEN Operation in SQL Server SELECT statement.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How to update if row exists else insert in SQL Server

Mar 13, 2022 by Beaulin Twinkle
Update If Row Exists Else Insert In SQL Server

Developing an application with database, frequently you will need to provide option to update if a row exists else insert a row.

Categories SQL Server Tags SQL, SQL Server 2019, SQL Tips, Transact-SQL (T-SQL) Leave a comment

How to update values in identity column in SQL Server?

Mar 6, 2022 by Beaulin Twinkle
How To Update Values In Identity Column

There is no straight forward way to update identity values. Here is a workaround I have followed to get the work done.

Categories SQL Server Tags SQL Server 2019, Transact-SQL (T-SQL) Leave a comment

How to calculate median in SQL Server?

Jul 14, 2022Feb 20, 2022 by Beaulin Twinkle
Calculate Median In SQL Server

Here is one another simple way to calculate median using the PERCENTILE_CONT function introduced in SQL Server 2012.

Categories SQL Server Tags SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017, SQL Server 2019, Transact-SQL (T-SQL) Leave a comment

How to import data from JSON file to SQL Server DB?

Feb 3, 2022 by Beaulin Twinkle
Import Data From JSON File To SQL Server

In this article, we will see how to import data from JSON file to a table using OPENROWSET and OPENJSON T-SQL relational operators.

Categories SQL Server Tags SQL, SQL Server 2019, Transact-SQL (T-SQL) 1 Comment

How to export a table to JSON file in SQL Server?

Jan 12, 2022 by Beaulin Twinkle

To export a table to JSON file, I have used FOR JSON clause to format the retrieved data as JSON and ran the BCP command through XP_CMSSHELL.

Categories SQL Server Tags SQL Server 2019, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) Leave a comment

How to enable XP_CMDSHELL in SQL Server?

Jan 7, 2022 by Beaulin Twinkle
Enable XP_CMDSHELL In SQL Server

Enable XP_CMDSHELL to fix the error “SQL Server blocked access to procedure ‘sys.xp_cmdshell’ of component because this component is turned off”

Categories SQL Server Tags Azure Data Studio, SQL Server 2019, SQL Sever Management Studio (SSMS), Transact-SQL (T-SQL) Leave a comment
Post navigation
Older posts
Page1 Page2 … Page18 Next →

Article Categories

  • Android (2)
  • Apple (19)
    • macOS (19)
  • Internet & Web Dev. (133)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • PHP (2)
    • Python (69)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (2)
  • Microsoft (288)
    • .Net (62)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (202)
    • Windows (23)
  • Networks And Distributed Systems (2)
  • Oracle (6)
    • Java (2)
    • Oracle Database (4)
  • Others (4)
  • Reviews (10)

Recent Articles

  • How to calculate Mean, Median and Mode in Python? Aug 3, 2022
  • How to calculate mode in C#? Jul 29, 2022
  • How to calculate mean In C#? Jul 21, 2022
  • How to calculate median in C#? Jul 20, 2022
  • How to calculate statistical mode in SQL Server? Jul 8, 2022
  • How to calculate mean in SQL Server? Jun 9, 2022
  • How to get execution time in milliseconds in SSMS? May 28, 2022
  • How to find whether the string contains a substring in Python? May 13, 2022
  • Reading XML file with PHP May 5, 2022
  • How to launch a PHP website on macOS? May 5, 2022

Subscribe MyTecBits.com

Online Tools

  • Fitness Calculators
  • Encoders & Decoders
  • Cryptography
  • Unit Converters
  • Math. Calculators
  • Date & Time Calculators
  • Finance Calculators

Popular Articles

  • SQL Server: Concatenate Multiple Rows Into Single String
  • How to compare contents of two files in Visual Studio Code?
  • How To Get Day Of Week In SQL Server?
  • SQL Server: Search and Find Table by Name
  • Find Indexes On A Table In SQL Server
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. Learn more...
  • Home
  • About Us
  • Contact Us
  • Site Map
  • Terms Of Use
  • Privacy Policy
© 2012 - 2022 My Tec Bits. All Rights Reserved.