Write a function to parse any row of the AA data / tanvimishra

Public

Edited

Oct 16, 2022

1 fork

# Write a function to parse *any* row of the AA data

Building on your assignment last week, convert your code to fit into a single function, which takes as input a single string that is a <tr> tag from any of the rows of raw AA data (from any of the zones). It should output ONE array or object, depending on how you have decided to structure your data; this array or object should also have nested array(s) and object(s), to have separate containers for each "meeting" (however you define meeting).

Here is an example of a very basic function that parses, reformats/restructures, and outputs the data into a desirable JS data structure:

https://observablehq.com/@aaronxhill/a-basic-string-function (Links to an external site.)

Your submission should be an Observable notebook (published!) and you will submit its url to Canvas.

Helpful documentation for functions in JS:

https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Functions (Links to an external site.) meetingParser('1buttercup2buttercup3')

Other resources:

https://www.freecodecamp.org/news/how-to-solve-coding-problems/

tr= ` <tr style="margin-bottom:10px">

<h4 style="margin:0;padding:0;">SRO Building</h4>

A CHANCE TO LIVE AGAIN - A Chance To Live Again

109 West 129th Street, Basement,

(@ Lenox Avenue) NY 10027

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Wednesdays From 6:00 PM to 7:00 PM Meeting Type BB = Big Book meeting

Mondays From 7:00 PM to 8:00 PM Meeting Type B = Beginners meeting

</td>

<a href="getdirections.cfm?meetingid=32" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Union Baptist Church</h4>

AA IT WORKS II - AA It Works II

240 West 145th Street,

(Betw 7th & 8th Avenues) NY 10039

Thu=Altern.BB, Living Sober & Other A.A. Literature. Fri.=Alternates between Step & Tradition.

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Wednesdays From 10:00 AM to 11:00 AM Meeting Type B = Beginners meeting

Thursdays From 10:00 AM to 11:00 AM Meeting Type BB = Big Book meeting

Fridays From 10:00 AM to 11:00 AM Meeting Type S = Step meeting

Tuesdays From 10:00 AM to 11:00 AM Meeting Type OD = Open Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=36" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Our Lady of Lourdes Church</h4>

ATTITUDE ADJUSTMENT - Attitude Adjustment

469 West 142nd Street, Basement,

(Betw Convent & Amsterdam Avenues) NY 10031

Topic 1st Saturday.

</div>

</td>

Saturdays From 7:30 AM to 8:30 AM Meeting Type OD = Open Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=58" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">St. Phillip Church</h4>

CONVENT -

204 West 134th Street, 1st Floor,

(Betw 7th & 8th Avenues) 10030

B-3rd Saturday

</div>

</td>

Saturdays From 11:30 AM to 1:00 PM Meeting Type OD = Open Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=1028" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Spiritual Renewal Church</h4>

FELLOWSHIP AT NOON - Fellowship At Noon

2044 Adam Clayton Powell Blvd.,

(@ 122nd Street) NY 10027

T If there is a fifth Wednesday.

</div>

</td>

Mondays From 12:15 PM to 1:15 PM Meeting Type B = Beginners meeting

Wednesdays From 12:15 PM to 1:15 PM Meeting Type S = Step meeting

Fridays From 12:15 PM to 1:15 PM Meeting Type OD = Open Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=151" class="GetDirections">Get Directions</a>

</td>

</tr>

GRUPO TRASMITELO -

469 West 142nd Street, 1st Floor,

(Betw. Amsterdam & Convent Avenues) 10031

Spanish speaking meeting.

</div>

</td>

Thursdays From 8:00 PM to 9:00 PM Meeting Type B = Beginners meeting

</td>

<a href="getdirections.cfm?meetingid=1366" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">St. Mary's Episcopal</h4>

HARLEM HUMANISTS -

521 W 126th St,

Amsterdam & Old Broadway 10027

Contact in Advance for Wheelcahir Accessibility

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Mondays From 12:00 PM to 1:00 PM Meeting Type O = Open meeting Special Interest Agnostic

</td>

<a href="getdirections.cfm?meetingid=1490" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">SRO Building Community Room</h4>

K.I.S.S. - Keep It Simple (Kiss)

109 West 129th Street, Basement,

(Betw Lenox Avenue & Adam Clayton Powell Blvd) NY 10027

All meetings are non-smoking.

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Sundays From 5:30 PM to 6:30 PM Meeting Type S = Step meeting

Sundays From 7:00 PM to 8:00 PM Meeting Type B = Beginners meeting

</td>

<a href="getdirections.cfm?meetingid=229" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Our Lady of Lourdes</h4>

LEARNING TO LIVE SOBER - Learning To Live Sober

469 West 142nd Street, Basement,

(Betw Convent & Amsterdam Avenues) NY 10031

</td>

Thursdays From 6:00 PM to 7:00 PM Meeting Type BB = Big Book meeting

</td>

<a href="getdirections.cfm?meetingid=232" class="GetDirections">Get Directions</a>

</td>

</tr>

LIVING CLEAN AND SOBER ON 121st STREET - Living Clean And Sober On 121st Street

2044 Seventh Avenue,

NY 10027

S 2nd, BB 3rd, OD 4th, Living Sober 5th wk.

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Sundays From 6:00 PM to 7:30 PM Meeting Type B = Beginners meeting

</td>

<a href="getdirections.cfm?meetingid=237" class="GetDirections">Get Directions</a>

</td>

</tr>

MEDITATION COMES TO HARLEM - Meditation Comes To Harlem

127 West 127th Street,

(Betw. 7th and Lenox) NY 10027

Meeting is closed on holidays

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Mondays From 4:30 PM to 5:30 PM Meeting Type C = Closed Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=246" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Grace Congregational Baptist Church</h4>

MID-HARLEM - Mid-Harlem

310 West 139th Street, Basement,

(Betw Eighth & Edgecombe Avenues) NY 10037

T 1st Monday at 7PM Open 1st Friday 8:10pm, Pitch other Fridays 8:10pm

</div>

</td>

Mondays From 7:00 PM to 8:00 PM Meeting Type S = Step meeting

Fridays From 7:00 PM to 8:00 PM Meeting Type B = Beginners meeting

Fridays From 8:00 PM to 9:00 PM Meeting Type O = Open meeting

</td>

<a href="getdirections.cfm?meetingid=250" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">St. James Church</h4>

MONDAY NIGHT CHALLENGE - Monday Night Challenge

409 West 141st Street, Basement,

(@ St. Nicholas Avenue) NY 10031

</td>

Mondays From 7:00 PM to 8:00 PM Meeting Type B = Beginners meeting

</td>

<a href="getdirections.cfm?meetingid=261" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Riverside Church</h4>

PRIMARY PURPOSE - Primary Purpose

91 Claremont Avenue, 4th Floor, Room 414,

(Betw. Broadway & Riverside Drive)) NY 10027

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Sundays From 3:00 PM to 4:00 PM Meeting Type OD = Open Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=303" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Upper Manhattan Mental Health Center</h4>

PROMISES TWO FOR ONE - Promises Two For One

1727 Amsterdam Avenue, 1st Floor in the rear.,

(@ 145th Street) NY 10031

1st Sun-OD; 2nd Sun-S; 3rd Sun-Topic; 4th Sun-T; 5th Sun-OD

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Sundays From 9:30 AM to 10:30 AM Meeting Type B = Beginners meeting

Sundays From 11:00 AM to 12:00 PM Meeting Type C = Closed Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=306" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Our Lady of Lourdes Church</h4>

REALITY CHECK - Reality Check

469 West 142nd Street, Basement,

(Betw Convent & Amsterdam Avenues) NY 10037

S 4th Saturday Men's Meeting

</div>

</td>

Saturdays From 5:00 PM to 6:00 PM Meeting Type OD = Open Discussion meeting Special Interest Men

</td>

<a href="getdirections.cfm?meetingid=308" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Riverside Church</h4>

RIVERSIDE - Riverside

91 Claremont Avenue, @ The Cloisters Club Room,

(1 Block West of Broadway & 1/2 Block North of 120th Street) NY 10027

Non-Smoking Meeting.

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Mondays From 7:00 PM to 8:00 PM Meeting Type C = Closed Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=315" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">St. Aloysius School</h4>

RIVERTON - Riverton

219 West 132nd Street, Cafeteria,

(Betw. Adam Clayton Powell Blvd. & F. Douglass Blvd.) NY 10027

S 2nd & T 4th Tue All meetings are non-smoking. No children allowed at meetings.

</div>

</td>

Saturdays From 3:00 PM to 4:00 PM Meeting Type B = Beginners meeting

Saturdays From 6:00 PM to 7:00 PM Meeting Type O = Open meeting

Tuesdays From 8:00 PM to 9:00 PM

</td>

<a href="getdirections.cfm?meetingid=316" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Salem United Methodist Church Community Center</h4>

SALEM - Salem

211 West 129th Street, Downstairs in the Gym,

(@ Adam Clayton Powell Blvd.) NY 10027

O 2nd Wednesday

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Wednesdays From 7:30 PM to 8:30 PM Meeting Type C = Closed Discussion meeting

</td>

<a href="getdirections.cfm?meetingid=320" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Convent Baptist Church Education Building</h4>

SOBER ADULT MEN - Sober Adult Men

425 West 144th Street, 1st Floor,

(Betw. Convent Avenue & Hamilton Terrace) NY 10031

Men's Meeting

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Wednesdays From 7:00 PM to 8:00 PM Meeting Type C = Closed Discussion meeting Special Interest Men

</td>

<a href="getdirections.cfm?meetingid=352" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">St. Phillip's Church</h4>

ST. NICHOLAS - St. Nicholas

204 West 134th Street, Basement,

(Betw Adam C. Powell & Frederick Douglas Blvds) NY 10030

S 2nd, C 3rd, BB 4th, & Grapevine 5th Thu.

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Sundays From 4:00 PM to 5:00 PM Meeting Type O = Open meeting

Thursdays From 7:00 PM to 8:00 PM Meeting Type B = Beginners meeting

</td>

<a href="getdirections.cfm?meetingid=363" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Harlem Hospital King Pavilion</h4>

STEPS 3 and 11 - Steps Three-Eleven

506 Lenox Avenue, Room #3101, 3rd Floor,

(@ 135 Street) NY 10037

B 1st, OD 2nd, S3 3rd, C Literature 4th, & S11 5th Sun.

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Sundays From 2:00 PM to 3:00 PM Meeting Type B = Beginners meeting

</td>

<a href="getdirections.cfm?meetingid=367" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Council Center for Problems of Living</h4>

SUGAR HILL -

1727 Amsterdam Avenue, 1st floor in the rear,

@ 145th St. 10031

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Fridays From 5:30 PM to 6:30 PM Meeting Type B = Beginners meeting

</td>

<a href="getdirections.cfm?meetingid=1575" class="GetDirections">Get Directions</a>

</td>

</tr>

TUESDAY BIG BOOK STUDY - Tuesday Big Book Study

1854 Amsterdam Avenue, Basment,

(Corner of 152nd Street) NY 10031

</td>

Tuesdays From 6:00 PM to 7:00 PM Meeting Type BB = Big Book meeting

</td>

<a href="getdirections.cfm?meetingid=390" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Our Lady of Lourdes Church</h4>

UPTOWN BIG BOOK WORKSHOP -

469 West 142nd Street, Basement,

(Betw. Convent & Amsterdam Avenues 10031

Meeting meets each Saturday from mid-August thru mid-December

</div>

</td>

Saturdays From 9:30 AM to 11:00 AM Meeting Type BB = Big Book meeting Special Interest Big Book Workshop

</td>

<a href="getdirections.cfm?meetingid=1428" class="GetDirections">Get Directions</a>

</td>

</tr>

<h4 style="margin:0;padding:0;">Metropolitan AME Church</h4>

YOU MAY CARE AFTER - You May Care After

58-66 West 135th Street,

(Betw Malcolm X Boulevard & 5th Avenue) NY 10037

Non-Smoking Meeting.

</div>

<img src="../images/wheelchair.jpg" alt="Wheelchair Access" width="20" vspace="5" hspace="10" align="absmiddle"/>Wheelchair access

</td>

Tuesdays From 6:30 PM to 7:30 PM Meeting Type S = Step meeting

</td>

<a href="getdirections.cfm?meetingid=432" class="GetDirections">Get Directions</a>

</td>

</tr>

metadata = cleanMetadata(tr)

metadataArray= metadata.split("</td>")

// split at td to see location details

function shortenmetadata (rawText) {

var newMetadata = metadata.split("</td>")[0]

return newMetadata

}

newMetadata = shortenmetadata(tr)

// create a function to include locationName, addressName, address, directionInstructions, state, and zipCode

function addressDetails (rawText) {

var locationDetails = {}

rawText= rawText.replace(`<h4 style="margin:0;padding:0;">`,"</h4>")

rawText= rawText.replace("","")

//LOCATION NAME

locationDetails.locationName = rawText.split("</h4>")[1]

//ADDRESS NAME

locationDetails.addressName = rawText.split("")[1]

//ADDRESS

locationDetails.address = rawText.split("")[2].split("\n")[1]

// DIRECTION INSTRUCTION

locationDetails.directionInstructions= rawText.split("")[2].split("\n")[2].split(" NY")[0]

//STATE

// locationDetails.state= "NY"

// //ZIP CODE

locationDetails.zipCode= rawText.split("")[2].split("\n")[2].substr(-5)//.split(" NY ")[1]

return locationDetails

}

addressDetails(newMetadata)

{var dataArray = []

for (let i= 0; i<78; i+=3){

dataArray.push(addressDetails(metadataArray[i]))

}

return dataArray

}

//splitting the rows up into

function splitRows(rawText) {

var meetingDaysList = [];

meetingDaysList = rawText.split("</td"); //[1]

return meetingDaysList;

}

splitRowsArr = splitRows(tr)

function SourceDayTimeRows(arr) {

var newArr = [];

for (let i = 1; i < arr.length; i += 3) {

newArr.push(arr[i]);

}

return newArr;

}

listOfRows = SourceDayTimeRows(splitRowsArr)

{

var meetingRowsArr = []; //all rows meeting info

listOfRows.forEach((row) => {

//for loop 1

row = row.split("\t ");

var meetingDateArr = []; //all days of the row info

for (let i = 1; i < row.length; i++) {

//for loop 2 + skipping i=0

meetingDateArr.push(meetingFunction(row[i]));

}

meetingRowsArr.push(meetingDateArr);

});

return meetingRowsArr;

}

listOfRows[1]

//listOfDays= meetingDays(tr)

//taking previous line and implementing it in a foreach fn

function splitRowDays(rowArr) {

var dayArr = [];

rowArr.forEach((day) => {

dayArr.push(meetingFunction(day));

});

return dayArr;

}

function meetingFunction(rawText) {

var meetingDetails = {};

rawText = rawText.replace("", " From ");

meetingDetails.days = rawText.split(" From ")[1];

meetingDetails.startTime = rawText.split("From ")[1].substring(0, 8);

meetingDetails.endTime = rawText.split(" ")[3].substring(0, 8);

meetingDetails.meetingType = rawText.split(" ")[4]; //still not working

return meetingDetails;

}

final =[]

// metadataArray.forEach(function(part){

// var part= part

// final.push({

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.

Learn more