Open in app
Home
Notifications
Lists
Stories

Write
Valliappan Thenappan
Valliappan Thenappan

Home

Apr 3, 2021

Finding Unique records in column of a giant CSV

When you are dealing with a giant datasets, Python is your best friend. I was tasked to find the unique records in a column in a ten million record dataset. For smaller datasets, its really easy to do it in excel this way: (1) Select a column, go to Data…

Pandas

2 min read

Finding Unique records in column of a giant CSV
Finding Unique records in column of a giant CSV

Apr 3, 2021

Splitting a giant CSV to smaller files in macOS

It was an eventful day where i got a request to review a 10 million row CSV. Tried to use excel in mac to open this giant file but excel couldn't even open the file completely: So what do i do? Like every sane person would do , i decided…

Csv

2 min read

Splitting a giant CSV to smaller files in macOS
Splitting a giant CSV to smaller files in macOS

Dec 22, 2020

How to use Python 2to3 Converter with Pycharm IDE

As a Python developer, we would be dealing with a lot of old python 2.x code which we would like to convert it to Python 3. Python by default provides us a nice command line utility called 2to3. You can read more about it here. But let us say we…

Python 2

2 min read

How to use Python 2to3 Converter with Pycharm IDE
How to use Python 2to3 Converter with Pycharm IDE

Sep 18, 2020

How to generate requirements.txt automatically for your python project using Pigar

As a Python Developer working on shared codebases, its always beneficial to generate a requirements.txt file for your projects, so that the dependencies can be managed better. How do we do this without spending too much time? An easier way is to generate the requirements.txt …

Python

1 min read

How to generate requirements.txt automatically for your python project using Pigar
How to generate requirements.txt automatically for your python project using Pigar

Jul 15, 2020

The curious case of ‘4’

There are times in your life where you think of this : ‘Things happen for no reason at all’ It all started on a precarious day where I wanted to get things done really quickly. Even when the entire county was shut-down amid a pandemic, there was optimism flowing through…

Funny

3 min read

The curious case of ‘4’
The curious case of ‘4’

Jul 3, 2020

How to Parameterize Dataset for an API Request using postman in Jenkins

As software engineers, we might run into a use case of running a batch job to fetch data from a resource using an API with a bulk dataset from time to time. …

Jenkins

3 min read

How to Parameterize Dataset for an API Request using postman in Jenkins
How to Parameterize Dataset for an API Request using postman in Jenkins

May 6, 2020

How to relax content security policy in Jenkins

A while ago, I used a fancy Reporting plugin for my tests and it looked great on my local machine. I was so happy seeing it and executed my tests on a Jenkins machine. …

Jenkins

2 min read

How to relax content security policy in Jenkins
How to relax content security policy in Jenkins

May 4, 2020

How to do a Cache Refresh and Reload on Google Chrome — The easy way

A Few days ago, I was trying to test the Site Speed of a certain page and needed an easier way to Clear cache and reload the page instead of multiple clicks. It seems there is a built-in option in Google Chrome to do this: Press F12 or open Dev Tools on your browser. Then right-click the Refresh icon on the page and Jackpot :

Chrome

1 min read

How to do a Cache Refresh and Reload on Google Chrome — The easy way
How to do a Cache Refresh and Reload on Google Chrome — The easy way
Valliappan Thenappan

Valliappan Thenappan

Distinguished Automation Test Engineer, Father and the Lazy

Following
  • Zhimin Zhan

    Zhimin Zhan

  • Ministry of Testing

    Ministry of Testing

  • Bhavani Ravi

    Bhavani Ravi

  • Gary Parker

    Gary Parker

  • QA Talks Community

    QA Talks Community

Help

Status

Writers

Blog

Careers

Privacy

Terms

About

Knowable