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

Frequently Asked Questions Python FAQ
1

Community%20FAQs%20on%20Codecademy%20Exercises
Community%20FAQs%20on%20Codecademy%20Exercises1000×208 141 KB

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!

2

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
3

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
4

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

1 Like
5

Agreed! Not sure why that is

6

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

1 Like
8

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
9

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
10

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
11

need to use ’ and not ´ on Devil’s

image

4 Likes
12

thanks, I was stuck in this one @@

13

The issue is still present as of July 2020

15

@moderators: this thread is old and no longer relevant since the bug in the exercise has been fixed. I would suggest closing this thread and create a new one to link to the exercise page.