Python Script to find invalid records.

Question

How can i write a python automation script which will work on CSV file level. Before the file gets process by a sql process, python script should read the file and mark invalid records which will avoid failing of sql process.

Answer 1

You can use pandas library. It basically is best suited for manipulating dataframes and it has a very powerful read_csv() method.
Once you read your data into a dataframe it is easily managed and mass-processed, so it shall suit your needs perfectly, as far as I can see.

Answer 2

oh thanks.. I will give a try.. let see it works for me.