All Questions
4
questions
1
vote
1
answer
1k
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
- 11
1
vote
0
answers
300
views
Excel intermittently opens blank excel and CSV files
I have a python script that reads info from MongoDB into a file. It can output either Excel or CSV files.
For some reason when I open the files it either opens as a blank document or showing the ...
- 155
1
vote
1
answer
928
views
convert sql-excel date to recognisable format
I have a large csv file(1.1G) exported from SQL Server. I would like to do data wrangling in python, but I had a few problems doing this. The original csv file dates look like this 00:07.5, 00:08.3, ...
- 115
1
vote
1
answer
902
views
Excel fails to open Python-generated CSV files
I have many Python scripts that output CSV files. It is occasionally convenient to open these files in Excel. After installing OS X Mavericks, Excel no longer opens these files properly: Excel doesn't ...
- 111