Featured Post

How to Check Column Nulls and Replace: Pandas

Here is a post that shows how to count Nulls and replace them with the value you want in the Pandas Dataframe. We have explained the process in two steps - Counting and Replacing the Null values. Count null values (column-wise) in Pandas ## count null values column-wise null_counts = df.isnull(). sum() print(null_counts) ``` Output: ``` Column1    1 Column2    1 Column3    5 dtype: int64 ``` In the above code, we first create a sample Pandas DataFrame `df` with some null values. Then, we use the `isnull()` function to create a DataFrame of the same shape as `df`, where each element is a boolean value indicating whether that element is null or not. Finally, we use the `sum()` function to count the number of null values in each column of the resulting DataFrame. The output shows the count of null values column-wise. to count null values column-wise: ``` df.isnull().sum() ``` ##Code snippet to count null values row-wise: ``` df.isnull().sum(axis=1) ``` In the above code, `df` is the Panda

Telecom Domain Knowledge Useful For a Data Analyst

Telecom companies provide five kinds of services. Those are Voice, Data, Toll-free, internet, and wireless. The given Telecom domain knowledge helpful for data analysis projects.

Telecom Domain Knowledge

5 Top Telecom Services.

  1. Voice
  2. Toll-free
  3. Data service
  4. Internet
  5. Wireless 

Telecom Domain Knowledge Useful for IT developers, Data Analysts, and Software Testers 

In addition to the above, the latest services are Internet and wireless. Domain knowledge is crucial to design and develop the code.

1. Voice service

This is the standard phone service that you have been using since the first time you called your Grandma to thank her for a birthday present. You need voice service.

2. Toll-free service

A toll-free number is a special-number; that enables calls to come in from anywhere without incurring a charge to the caller. The called party pays a toll tariff for the Call. How much the called party pays for a call depends on the arrangements made with the long-distance carrier. 

If you look at all of your voice calls and find that majority of them are inbound from customers, you could probably benefit from toll-free service.

For many companies, not having a toll-free number is disastrous. If your car breaks down and you have to call for assistance from a payphone, would you rather pay 50 cents to contact the answering machine of a tow truck or taxi company, or would you call for free? If you’re on hold for a couple of minutes on a toll-free call, at least you’re not paying for it.

3. Data services

The term data services usually refer to non-voice communications such as e-mail, text messaging, and fax services that transmit over a private network. In every company, information needs to travel from one side of the office to another side. 

The sales team closes the order and relays it to the order-entry department. The order-entry department logs the order and sends it to the manufacturing department; the manufacturing department builds and tracks the order, and the Shipping department sends the order to the customer. 

4. Internet Service

Every office needs a connection to the Internet to send and receive e-mail when the employees away. Companies use the Internet to research their competitors. Also, use to visit suppliers’ Websites to place orders, review shipments, and request services.

5. Wireless service

Wireless service can encompass all the other categories. The wireless-service;  is a third party service - a different company other than the one that provides your landlines. So you need to view it as a separate telecom service.


Popular posts from this blog

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers

6 Python file Methods Real Usage