Data Cleaning done on eCourts Data | Tech and Data

Update the name of the Acts.

• all combinations of Information Technology Act, IT act > 'The Information Technology Act,2000'.

   update act
   set name='The Information Technology Act, 2000'
   where name in ('INFORMATION TECHNOLOGY ACT', 'Information Technology Act', 'IT act');
  

• all combinations of Indian Penal Code, IPC > 'Indian Penal Code'

    update act
    set name='Indian Penal Code'
    where name in ('INDIAN PENAL CODE', '2 IPC', '2 INDIAN PENAL CODE', '1 Indian Penal Code', 'IPC');