Mar-10-2020, 08:34 PM
Hi friends, I work in research/data science but am new to Python. I have historically used SAS Enterprise Guide for my needs. Since my work constantly involves data exploration, cleanup, and reconciliation - including emailing spreadsheets of my data to other persons for revision - I greatly value a feature in Enterprise Guide which allows me to quickly browse working datasets in Excel-like spreadsheets. After writing SAS code to produce and modify several datasets, which may be temporary or permanent, I can then click on a different tab within Enterprise Guide to browse through full spreadsheets of the data. If I want to copy values from one or more cells, I simply select those cells and copy. If I want to export the dataset that I'm currently exploring to an Excel spreadsheet, there is a handy button to do so.
I want to explore switching from SAS to Python but am struggling to find a development environment which provides this functionality. Exporting to Excel spreadsheets with the simple click of a button is nice but not necessary. What I really need is a piece of software which allows me to write some code and then browse through any datasets (dataframes) that have been constructed with said code in an Excel-like interface. Sure, I can use head() or tail() to peek at the data in console, but the output is poorly aligned, difficult to quickly copy one or more cells, doesn't show all columns and rows by default, doesn't lend itself to browsing, and is rather ugly. I tried Jupyter Notebook and its output was a little cleaner but still didn't seem to have a dedicated feature for browsing through active dataframes.
The ability to browse through ALL constructed/imported datasets/dataframes in an Excel-like fashion, through Enterprise Guide, has so dramatically improved my workflow that I imagine there must be something equivalent for Python. Can anyone recommend something that might suit my needs? Thank you!!
I want to explore switching from SAS to Python but am struggling to find a development environment which provides this functionality. Exporting to Excel spreadsheets with the simple click of a button is nice but not necessary. What I really need is a piece of software which allows me to write some code and then browse through any datasets (dataframes) that have been constructed with said code in an Excel-like interface. Sure, I can use head() or tail() to peek at the data in console, but the output is poorly aligned, difficult to quickly copy one or more cells, doesn't show all columns and rows by default, doesn't lend itself to browsing, and is rather ugly. I tried Jupyter Notebook and its output was a little cleaner but still didn't seem to have a dedicated feature for browsing through active dataframes.
The ability to browse through ALL constructed/imported datasets/dataframes in an Excel-like fashion, through Enterprise Guide, has so dramatically improved my workflow that I imagine there must be something equivalent for Python. Can anyone recommend something that might suit my needs? Thank you!!