excel not reading some data

Question

I used Python to build a CSV file containing 150 columns, each of which should have the values 0, 1, or 2. I open Excel, enter data, obtain the data from text, select the comma as the delimiter, etc. The issue is that only the first column has been appropriately filled with the desired data; the remaining 149 columns are all empty. Yet, it seems nice and each column is filled appropriately when I load that file in PyCharm, where I typed the code.

I saved the data using

allData.to_csv('allData.csv', index=False)

Answer 1

When using the sep option in the to csv method to save the CSV file, you can consider explicitly specifying the delimiter to a comma. Here is a sample of the code:

import pandas as pd
# Create a sample DataFrame with 150 columns containing 0, 1, or 2
data = pd.DataFrame({'col_' + str(i): [0, 1, 2] for i in range(150)})
# Save the data to a CSV file with comma as delimiter
data.to_csv('allData.csv', index=False, sep=',')