I would like to import a csv file with headers to pandas. Somehow, pandas appends a “.7” to the last headers name

I am using jupyter notebook to practice Python skills. And I am having some problems creating a dataframe correctly using some of Kaggle datasets. I am not being able to know exactly how to do it. Here is the link to kaggle to find them
https://www.kaggle.com/datasets/shivamb/netflix-shows/data
https://www.kaggle.com/datasets/mlg-ulb/creditcardfraud

I am working on a small program and need some guidance.

I have a CSV file that all values located into one column. How can I open this CSV into the Python and separate the values into multiple columns.

I am faced with reading a .csv file with some columns like this:

I am trying to save a pandas data frame to csv the data frame is made up of lists that I made into a dictionary. The len of each list is consistent at 3000 whenever I convert the data frame into a CSV add unwanted row breaks two random rows near the bottom of the file. There are no NaN values and no hidden text either. All the lists are saved as dtype objects except for one that is int64. I’ve never experienced a problem like this and I’m stumped. Any help is greatly appreciated.

I have two different CSV files – old.csv and new.csv. they are with a different number of rows and columns. the CSV files can include numbers, strings, chars, and special characters. For example:

The issue arises when subtracting the product of the population and literacy percentage from the population in a pandas Data Frame, resulting in negative values for the number of illiterate people. It should yield positive values, but it doesn’t. Also the number is wrong, as it should subtract the number of literate from the total population, but eg. China’s number is around 1 billion, when it should be around 100 million. Here is the link to the CSV file https://github.com/bnokoro/Data-Science/blob/master/countries%20of%20the%20world.csv

The issue arises when subtracting the product of the population and literacy percentage from the population in a pandas Data Frame, resulting in negative values for the number of illiterate people. It should yield positive values, but it doesn’t. Also the number is wrong, as it should subtract the number of literate from the total population, but eg. China’s number is around 1 billion, when it should be around 100 million. Here is the link to the CSV file https://github.com/bnokoro/Data-Science/blob/master/countries%20of%20the%20world.csv The code

I am trying to loop over over a directory with multiple CSV’s and read them into (seperate) pandas dataframes.
I have tried several methods but i cannot manage to do so. However I did manage to read the csv’s and put them into a list, but when trying to read a csv file, my python does not find the file.