MicrosoftLearning / mslearn-fabric

This repository hosts content related to Microsoft Fabric content on Microsoft Learn.
https://microsoftlearning.github.io/mslearn-fabric/
MIT License
184 stars 144 forks source link

Lab8 and pandas loading generated code #24

Closed mycaule closed 1 year ago

mycaule commented 1 year ago

Lab 8

Description of issue

Repro steps:

  1. Copy the churn.csv to a subfolder named data/
  2. load the churn.csv file with pandas with a Notebook from this step
  3. FileNotFoundError
import pandas as pd
# Load data into pandas DataFrame from "/lakehouse/default/" + "Files/churn.csv"
df = pd.read_csv("/lakehouse/default/" + "Files/churn.csv")
display(df)

Generated code missed the subfolder data/

Mihai-Ac commented 1 year ago

Hello @mycaule

The instructions do not mention any data folder for the churn.csv file. The file should be uploaded in the Files node. In the case that a student created a folder and uploaded the churn.csv file in there, the student can : Navigate to the file, select the ellipsis ... , from there select Load data and then select Pandas. This will create a new cell in the notebook with the required code to load the content of that file.

Best regards, Mihai