I have an Excel spreadsheet with a column formatted as "General" containing values like 10cm, 0, 1, TRUE, and FALSE. I am using Pandas to parse the data into a dataframe and then save it in an SQLite table. However, I want the values in this column to retain their original formats.
So far, I have used xl=pd.ExcelFile() to read the file and xl.parse() to extract the data. But when parsing, the FALSE value in the column is being converted to 0, which creates confusion with actual 0 values. The code snippet causing the issue is:
df=xl.parse(sheet_name=sheet,names=columns,skiprows=2)
The variable 'sheet' represents the given sheet name, while 'columns' is a list of column names.
Can anyone provide assistance in resolving this problem?