Posts

Showing posts with the label tableau tabadmin commands

Featured Post

How to Check Column Nulls and Replace: Pandas

Image
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

5 Tableau Features Useful for Data Analytics

Image
Below are the top Tableau features for data analytics. Tableau 9 for Data Science engineers. CONNECTING TO LOCAL FILE  Tableau can connect to any local file or database such as Excel  Text File Access  Statistical File, or  Another Database file CONNECTING TO SERVER Tableau can connect to your data server too. It can connect to almost any type of data server. Below are some of the most popular databases that Tableau can connect: Tableau Server Google Analytics Google BigQuery Hortonworks Hadoop Hive MapR Hadoop Hive IBM DB2 IBM BigInsights IBM Netezza Microsoft SQL Server Microsoft Analysis Services Oracle Oracle Essbase MySQL PostgreSQL SAP While working on Tableau, data can have Live Connection where any change in the source data will be automatically updated in Tableau. On the other hand, data can be Extracted to the Tableau repository so that any change made here will not affect the original source data. CONNECTING TO EXCEL FILE To connect