I don't know know how to extract the useful data and form a CSV file in Chuck Norris Jokes problem

18127 · July 24, 2020, 12:24pm

I have completed all the previous lectures but I am not able to understand how to make a CSV file. I hav extracted the jokes from the url,converted them to python dictionary and need guidance in the further steps.

prashant_ml · July 24, 2020, 2:32pm

hey @18127 ,
we are here to help you if you get stuck at any point , but before i help you .
I would suggest you to first understand search about on how to convert a dictionary to a csv file.
I can provide you directly the code , but that will not help learn something.

for a bit help , search about pandas module and specifically its .from_dict() function.
if still you get stuck somewhere , just ask me . I will help you at that point.

Thank You and Happy Learning .

18127 · July 24, 2020, 4:14pm

I will read that, thank you.

18127 · July 24, 2020, 4:15pm

However, i just wanted to know if it can be done by any method that you have already taught in previous lectures, i.e. just like we did html parsing or something.

prashant_ml · July 24, 2020, 4:56pm

not exactly , but similar to it, creating csv files will be taught in either pandas series or python basics series.

18127 · July 27, 2020, 5:38am

It has been 2 days since I submitted my CSV file, can you tell me when will I get the result

prashant_ml · July 27, 2020, 2:49pm

you should have got your result at the same time after uploading it.
There might be some problem .
Do one thing share me your csv file , i will let you know what you score is.

18127 · July 28, 2020, 10:15am

How can I share the file with you ?
Can I send you the code ?

prashant_ml · July 28, 2020, 10:20am

you can either upload it on github or drive and share me its link.

18127 · July 28, 2020, 12:41pm

github.com

AdityaGupta235/Coding-Blocks/blob/master/jokes.csv

ID,Joke

1,"Chuck Norris uses ribbed condoms inside out, so he gets the pleasure."

2,MacGyver can build an airplane out of gum and paper clips. Chuck Norris can kill him and take it.

3,Chuck Norris doesn't read books. He stares them down until he gets the information he wants.

4,"If you ask Chuck Norris what time it is, he always answers &quot;Two seconds till&quot;. After you ask &quot;Two seconds to what?&quot;, he roundhouse kicks you in the face."

5,Chuck Norris lost his virginity before his dad did.

6,"Since 1940, the year Chuck Norris was born, roundhouse kick related deaths have increased 13,000 percent."

12,Chuck Norris sheds his skin twice a year.

13,Chuck Norris once challenged Lance Armstrong in a &quot;Who has more testicles?&quot; contest. Chuck Norris won by 5.

14,There are no steroids in baseball. Just players Chuck Norris has breathed on.

15,"When Chuck Norris goes to donate blood, he declines the syringe, and instead requests a hand gun and a bucket."

16,Pluto is actually an orbiting group of British soldiers from the American Revolution who entered space after the Chuck gave them a roundhouse kick to the face.

17,Chuck Norris does not teabag the ladies. He potato-sacks them.

18,"According to the Encyclopedia Brittanica, the Native American &quot;Trail of Tears&quot; has been redefined as anywhere that Chuck Norris walks."

19,"In an average living room there are 1,242 objects Chuck Norris could use to kill you, including the room itself."

20,"The Chuck Norris military unit was not used in the game Civilization 4, because a single Chuck Norris could defeat the entire combined nations of the world in one turn."

21,"Chuck Norris doesn't shower, he only takes blood baths."

23,Time waits for no man. Unless that man is Chuck Norris.

24,Chuck Norris can hit you so hard that he can actually alter your DNA. Decades from now your descendants will occasionally clutch their heads and yell &quot;What The Hell was That?&quot;.

25,"In the Bible, Jesus turned water into wine. But then Chuck Norris turned that wine into beer."

This file has been truncated. show original

prashant_ml · July 28, 2020, 5:04pm

hey @18127,
Nice work dude.
You have got 100% accuracy .
The actual problem is the way are creating your file. If we read your file with csv module at each alternate line it contains an empty space, which our script running at the server can’t understand and hence wasn’t able to show you the results.
You may correct that and try again .

Thank You .

18127 · August 1, 2020, 1:06pm

github.com

AdityaGupta235/Coding-Blocks/blob/master/Chuck Norris.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests, csv\n",
    "import pandas as pd\n",
    "import json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "metadata": {},
   "outputs": [],
   "source": [
    "url = \"https://api.icndb.com/jokes/json?\""

This file has been truncated. show original

18127 · August 1, 2020, 1:07pm

This is the link of my code, can you please let me know where is the error and how can I correct it

prashant_ml · August 2, 2020, 6:18am

Kindly let me have a look once. Will tell you after that.

Thank You

prashant_ml · August 2, 2020, 8:27am

just replace your last code snippet with

f_names=['ID', 'Joke']
csv_file = 'jokes.csv'
with open(csv_file,'w') as f:
f.write(",".join(f_names)+"\n")
# writer.writerow(f_names)
for i in dic_data:
id = i['id']
joke = i['joke']
if joke.find(",") != -1:
joke = '"{}"'.format(joke)
f.write(",".join([str(id),joke])+"\n")

it will do your task,