How to import dataframe from .py file to .ipynb file?

user_17141012 0
Viewed 126

I am trying to import a dataframe from funcs.py file to data.ipynb file, both are in the same directory

funcs.py

df_course = pd.read_sql('SELECT COURSEID, COURSENAME FROM COURSE', con=conn)

here conn is the pyodbc connection , it is working fine as i am able to view dataframe in funcs.py

error

When i tried to import df_course in data.ipynb it is giving me error, i am doing like this

import funcs.df_course as df_course

but it is giving me error that cannot import df_course from funcs

Please help me in this problem

jupyter pandas python
4 Answers

Simply use:

from funcs import df_course

because funcs is not a package, a directory that contains an __init__.py file.

user_152399510

Try this:

import sys
function_path = r'C:\Users\hogsione\jupyter' # Path of funcs.py file
sys.path.insert(1, function_path)

# Now import df_course
from funcs import df_course
user_165566940

Instead Of import funcs.df_course as df_course;

Use This:- from funcs import df_course as df_course

For The Name That You Want, as df_course is not necessary, but if u want to import it as df or something, then you can use df_course..

user_176000480
user_149682010
Related