FAQ: Creating, Loading, and Selecting Data with Pandas - Comma Separated Variables (CSV)

This community-built FAQ covers the “Comma Separated Variables (CSV)” exercise from the lesson “Creating, Loading, and Selecting Data with Pandas”.

Paths and Courses
This exercise can be found in the following Codecademy content:

Data Science

Data Analysis with Pandas

FAQs on the exercise Comma Separated Variables (CSV)

Join the Discussion. Help a fellow learner on their journey.

Ask or answer a question about this exercise by clicking reply (reply) below!

Agree with a comment or answer? Like (like) to up-vote the contribution!

Need broader help or resources? Head here.

Looking for motivation to keep learning? Join our wider discussions.

Learn more about how to use this guide.

Found a bug? Report it!

Have a question about your account or billing? Reach out to our customer support team!

None of the above? Find out where to ask other questions here!

In the context of this exercise on Comma Separated Values, the example cell of Carrot cake is written as Carrot Cake.
Yet in the solution, the hint insisted that it’s written as Carrot cake, not Carrot Cake
Why?

1 Like

Surprisingly for me, but the next input is not accepted. All column names and variables are entered using commas, without spaces. Every row separated by hitting Enter(Return). Have no clue what I’m doing wrong

name,cake_flavor,frosting_flavor,topping
Devil’s Food,chocolate,chocolate,chocolate shavings
Birthday Cake,vanilla,vanilla,rainbow sprinkles
Carrot Cake,carrot,cream cheese,almonds

6 Likes

Only when I looked to solution, I understood what you meant. Yep, not obvious

Agreed! Not sure why that is

This lesson is broken because of a capitalization error. “Carrot cake”

1 Like

I changed “Carrot Cake” to “Carrot cake” as mentioned but it still gives a wrong result. Here is what I used:

name,cake_flavor,frosting_flavor,topping
Devil’s Food,chocolate,chocolate,chocolate shavings
Birthday Cake,vanilla,vanilla,rainbow sprinkles
Carrot cake,carrot,cream cheese,almonds

The problem was with the single quote character on “Devil’s Food”. When you copy from the example input, delete it and add a new one. The one being copied is not the same one they use in the result.

5 Likes

This problem is still there as of May 2, 2020 - The required capitalization is different from what is provided in the instructions. This bug is causing problems for everyone who attempts the course.

1 Like

need to use ’ and not ´ on Devil’s

image

4 Likes

thanks, I was stuck in this one @@

The issue is still present as of July 2020