Python Forum
Python Forum

Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: How to schedule Jupyter Notebooks with Papermill
Post: How to schedule Jupyter Notebooks with Papermill
Hello, Does anyone know a good source with examples of how to schedule Jupyter Notebooks with Papermill using Anaconda? Thank you, Wendy
 wendysling General Coding Help 0 2,500 Jun-11-2019, 05:53 PM
    Thread: Python not reading cell in excel file
Post: Python not reading cell in excel file
Hi, I am using Jupyter notebook. I created a script to open a few excel files and paste a summary dataframe in a new excel file. All was working fine, but somehow today the coding is not capturing...
 wendysling General Coding Help 1 2,144 May-21-2019, 07:59 PM
    Thread: Looping a function
Post: RE: Looping a function
Thank you. This is working. But the columns are not appending to the original dataframe, as I can't add dataframe2 = dataframe.assign(month=''). So how can I append the new columns to the original da...
 wendysling General Coding Help 3 2,152 May-09-2019, 09:53 PM
    Thread: Looping a function
Post: Looping a function
Hello, I am trying to run a function that creates additional columns in a data frame in case the column is missing. The columns are for months. If the month is missing, the function should create a...
 wendysling General Coding Help 3 2,152 May-09-2019, 07:14 PM
    Thread: How to add a dataframe to an existing excel file
Post: RE: How to add a dataframe to an existing excel fi...
I found a way around like this. from openpyxl import load_workbook workbook1 = openpyxl.load_workbook('file.xlsx') writer = pd.ExcelWriter('file.xlsx', engine='openpyxl') writer.book = workbook1 n...
 wendysling Data Science 2 28,158 May-09-2019, 07:00 PM
    Thread: How to add a dataframe to an existing excel file
Post: How to add a dataframe to an existing excel file
Hello, I am trying to add a dataframe to an existing sheet. I don't see any error, but the data does not show on the sheet. Is anyone able to tell me what am I missing? Thank you! #Grab datafra...
 wendysling Data Science 2 28,158 May-07-2019, 08:50 PM
    Thread: Replacing an integer by looking at a dictionary
Post: RE: Replacing an integer by looking at a dictionar...
This is helpful to change the number for a text.
 wendysling General Coding Help 3 2,288 May-02-2019, 03:38 PM
    Thread: Replacing an integer by looking at a dictionary
Post: Replacing an integer by looking at a dictionary
Hi, I am trying to find the current month in a dataframe to pull other information from that specific month. Datetime provides the month as a number. However, my dataframe has columns with the Mon...
 wendysling General Coding Help 3 2,288 Apr-30-2019, 05:33 PM
    Thread: Manipulating Series in Dataframe (Pandas)
Post: RE: Manipulating Series in Dataframe (Pandas)
This worked: df.loc[df.loc[:, 'DateColumn'].dt.year == 2017, :] Thank you!
 wendysling Data Science 2 2,723 Mar-26-2019, 07:12 PM
    Thread: Installing libraries
Post: RE: Installing libraries
Thank you for the help! I realized I don't have access to installing packages on my work PC. I am working on this first, then I will be able to follow your recommendations. Thanks again!
 wendysling General Coding Help 3 3,763 Mar-25-2019, 04:57 PM
    Thread: Manipulating Series in Dataframe (Pandas)
Post: Manipulating Series in Dataframe (Pandas)
Hi, I have a date column in a data frame that looks like this: (Year-Month-Day) 2017-09-21 2018-11-25 I am trying to create a function that considers only the year, I have been trying the followin...
 wendysling Data Science 2 2,723 Mar-25-2019, 04:24 PM
    Thread: Installing libraries
Post: Installing libraries
Hello, I am trying to install the following libraries while using Jupyter, and I have Anaconda installed in my pc. However, when I write the below in command prompt, it says "'conda' is not recogni...
 wendysling General Coding Help 3 3,763 Mar-24-2019, 04:51 PM
    Thread: Automating Excel sheets with Python
Post: Automating Excel sheets with Python
Hi, Does anyone have recommendations in terms of resources for someone trying to learn how to automate Excel spreadsheets using Python? Thank you so much! Wendy
 wendysling General Coding Help 1 2,566 Mar-15-2019, 01:25 PM

User Panel Messages

Log Out
My Profile
Pay your profile a visit
User Control Panel
Do some changes on your profile
My Messages
View private messages unread
Avatar
Change avatar
Signature
Change signature
Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020