Yes sure it still works. But, you must do something before importing. Check that data is cleaned as much as possible, you can do this on excel for example. Check that all nan cells contain empty string no spaces no characters are there. Best of luck!
in your case, You can use the load data infile statement. This video method is also applicable, but you can perform it multiple times. For example, you can divide your rows into smaller parts and load each part separately into your database. Hope it helps.
bro i want to import csv file containing 60000 rows into wix but there is a limit of 50,000 rows so i am trying to upload it to mysql(external database option) how do i achieve this?
@Data Analytics - Thanks for sharing it. I tried it and its working for first time and second time its throwing error "'tuple' object is not callable" Can you please help?
@@AnalyticsExplorers - i did not change anything. i have found another way to handle this issue and its working fine y = [] for index, row in df1.iterrows(): x = tuple(row) y.append(x) y
