Aggregation of fields is one of the basic necessity for data analysis and data science. Python’s Pandas module provide easy ways to do aggregation and calculate metrics. Finding maximum value for each group can also be achieved while doing the

Read More

Text fields require good amount of cleaning before starting data analysis. Python Pandas has many functions that helps working with text columns in easier ways. There can be a requirement to extract letters from right side in a text value,

Read More

Text fields require good amount of cleaning before starting data analysis. Python Pandas has many functions that helps working with text columns in easier ways. There can be a requirement to extract letters from left in a text value, in

Read More

Keeping text in right format is always important. The data coming out of Python eventually helps in presenting the insights. In case the texts are not in proper format, it will require additional cleaning in later stages. Fields can be

Read More

Keeping text in right format is always important. The data coming out of Python eventually helps in presenting the insights. In case the texts are not in proper format, it will require additional cleaning in later stages. Fields can be

Read More

Keeping text in right format is always important. The data coming out of Python eventually helps in presenting the insights. In case the texts are not in proper format, it will require additional cleaning in later stages. Fields can be

Read More

Comparison of text between cells is possible in Excel through an Excel Formula. Exact function helps in comparing 2 cells, to check if the values within the cell is matching exactly. This function can be very helpful, as various use

Read More