Robyn | Robyn is an experimental, automated and open-sourced Marketing Mix Modeling (MMM) package from Faceb | Machine Learning library

I'm currently working on a project that cross validate 2 sheets with approx 500 loops.

ROSTER

First Name Last Name DoB Judith Barragan 4/10/1959 Kelly Benitez 9/14/1993 Martha Bustos 1/12/1960 Robyn Carroll 5/9/1954 Janet Chambers 8/27/1949 Nikki Corso 10/25/1957 Angella Decohen 5/23/1988 Damian Delaney 6/26/1961 Anora Denison 4/14/1998 Cristina Dimatulac 7/28/1959 Mercy Erazo 3/14/1959 Michelle Fanara 11/20/1981 Shannon Feldmann 9/10/1986 Alejandra Frutos-Silva 2/14/1978 Rebecka Aceves 7/14/2007 Jarely Aguilera 6/8/2006 Jasmine Aguillon 1/29/2007 Adriana Alaniz 10/4/2007 Blanca Angel 11/3/2007 Francie Arellano 9/11/2007 Molly Barajas 10/1/2007 Emily Barranco 9/12/2007 Valeria Bata 3/29/2007 Sarahi Cabeza 8/8/2007 Carla Cadena 3/31/2006 Emily Cano 1/25/2007 Janet Canul 4/27/2007 Caitlyn Castaneda 3/26/2007 Jacqueline Castillo 1/22/2007 Melanie Colindres 6/8/2007 Nyah Davis 8/8/2007 Karie Delgadillo 2/10/2007 Gabriela Diaz 6/25/2007 Helen Diaz 8/17/2007 Hailey Duran 5/20/2007 Hazel Flores 9/7/2007 Kiherra Gamboa 10/4/2007 Belen Gonzalez 4/23/2007 Samantha Gonzalez 10/16/2007 Ashlee Palacios 8/31/2006 Naomi Papaqui 5/17/2007 Karely Paxtor 10/21/2006 Michelle Paxtor 10/20/2007 Audra Perez 2/24/2007 Josueline Perez 10/30/2006 Yaretzi Pineda 2/17/2007 Zuleyka Portela 9/10/2007 Jacqueline Prudencio 3/1/2007 Destiny Quiroz 5/10/2007 Kelcey Raiz 5/11/2007 Brianna Ramos 8/15/2007 Neydy Renderos 8/26/2007 Daiman Johnson 3/3/1968 Kimberley Rivas 11/2/2007 Michelle Dominguez 5/15/2005 Marleny Rodriguez 7/29/2007 Maria Roman 5/9/2006 Cristal Solis 9/29/2006 Carmela Torralba 6/28/2007 Dora Vasquez 5/14/2007 Cindy Vega 11/20/2007 Jennifer Velasco 6/30/2006 Chloe Wilson 10/8/2007 Melody Zacarias 5/17/2007 Hazel Zamora 1/27/2007 Kayden Alexander 2/6/2006 Yvette Alvarado 3/30/2006 Damian Delaney 6/26/1961 Kimberly Amezcua 7/14/2006 Kimberly Antonio 5/30/2006 Alicia Aquino 6/15/2006 Samantha Aquino 6/27/2006 Destiny Arauz 6/13/2006 Julissa Arroyo 5/26/2006 Cassandra Ayala 8/18/2006 Samantha Ayala 7/2/2006 Eva Azul 2/6/2006 Stacey Bacelis 4/4/2006 America Baires 7/17/2006 Ashley Barajas 6/10/2005 Janet Barrera 10/14/2005 Alisa Benitez 5/26/2006 Sara Bolanos-Mejia 1/12/2006 Ashley Mendez 6/22/2006 Ana Carvente 7/12/2006 Mia Castellanos 6/19/2006 Rosalma Cebreros 3/3/2006 Yosselin Celis 5/25/2005 Jacqueline Lucero 9/2/1974 Evelyn Chamu 1/30/2006 Nataly Chavez 2/27/2006 Juliana Coeto 10/4/2005 Shesith Covarrubias 12/8/2005 Ashley Cruz 7/20/2006 Erin Dakers 8/2/2007 Claudia Lopez 6/16/2007 Cristina Diaz 10/13/2005 Zoe Dighero 4/11/2006 Kaylynn Domingo 10/4/2006 Celeste Dominguez 6/1/2006 Lizzy Escobar 12/14/2005 Lilian Escorza 12/23/2005

REGISTRATION

First Name Last Name DoB Jacqueline Lucero 9/2/1974 Ashley Mendez 6/22/2006 Hyobe Namkoong 6/19/2007 Hetzabel Sanchez 4/13/2005 cristal solis 9/29/2006 Briseida Lopez 5/22/2005 Daiman Johnson 3/3/1968 Kayleen Vasquez 12/9/2003 Ashley Aguilar 12/9/2003 Damian Delaney 6/26/1961 Michelle Dominguez 5/15/2005 Martha Bustos 1/12/1960 Jaqueline Granadino 9/6/2004 jacqueline granadino 9/6/2004 Jacqueline granadino 9/6/2004 Maria Gutierrez 11/30/2006 Claudia Lopez 6/16/2007 Kelly Benitez 9/14/1993 Kelly Benitez 9/14/1993

RESULT

First Name Last Name DoB Start Code Jacqueline Lucero 9/2/1974 1980001 Ashley Mendez 6/22/2006 1980002 Cristal Solis 9/29/2006 1980003 Daiman Johnson 3/3/1968 1980004 Damian Delaney 6/26/1961 1980005 Michelle Dominguez 5/15/2005 1980006 Martha Bustos 1/12/1960 1980007 Claudia Lopez 6/16/2007 1980008 Kelly Benitez 9/14/1993 1980009

Sample Data Sheet my problem is that my script sometimes getting run-time timeout. I am seeing map function but I'm not sure if it's applicable for my current problem.

here are my sheets that is included in my script. sheets are roster, form responses 1, reference, result. roster and registration tab have common columns (First name, Last Name, Date of Birth)

...

I'm currently working on a project that cross validate 2 sheets with approx 500 loops.

ROSTER

First Name Last Name DoB Judith Barragan 4/10/1959 Kelly Benitez 9/14/1993 Martha Bustos 1/12/1960 Robyn Carroll 5/9/1954 Janet Chambers 8/27/1949 Nikki Corso 10/25/1957 Angella Decohen 5/23/1988 Damian Delaney 6/26/1961 Anora Denison 4/14/1998 Cristina Dimatulac 7/28/1959 Mercy Erazo 3/14/1959 Michelle Fanara 11/20/1981 Shannon Feldmann 9/10/1986 Alejandra Frutos-Silva 2/14/1978 Rebecka Aceves 7/14/2007 Jarely Aguilera 6/8/2006 Jasmine Aguillon 1/29/2007 Adriana Alaniz 10/4/2007 Blanca Angel 11/3/2007 Francie Arellano 9/11/2007 Molly Barajas 10/1/2007 Emily Barranco 9/12/2007 Valeria Bata 3/29/2007 Sarahi Cabeza 8/8/2007 Carla Cadena 3/31/2006 Emily Cano 1/25/2007 Janet Canul 4/27/2007 Caitlyn Castaneda 3/26/2007 Jacqueline Castillo 1/22/2007 Melanie Colindres 6/8/2007 Nyah Davis 8/8/2007 Karie Delgadillo 2/10/2007 Gabriela Diaz 6/25/2007 Helen Diaz 8/17/2007 Hailey Duran 5/20/2007 Hazel Flores 9/7/2007 Kiherra Gamboa 10/4/2007 Belen Gonzalez 4/23/2007 Samantha Gonzalez 10/16/2007 Ashlee Palacios 8/31/2006 Naomi Papaqui 5/17/2007 Karely Paxtor 10/21/2006 Michelle Paxtor 10/20/2007 Audra Perez 2/24/2007 Josueline Perez 10/30/2006 Yaretzi Pineda 2/17/2007 Zuleyka Portela 9/10/2007 Jacqueline Prudencio 3/1/2007 Destiny Quiroz 5/10/2007 Kelcey Raiz 5/11/2007 Brianna Ramos 8/15/2007 Neydy Renderos 8/26/2007 Daiman Johnson 3/3/1968 Kimberley Rivas 11/2/2007 Michelle Dominguez 5/15/2005 Marleny Rodriguez 7/29/2007 Maria Roman 5/9/2006 Cristal Solis 9/29/2006 Carmela Torralba 6/28/2007 Dora Vasquez 5/14/2007 Cindy Vega 11/20/2007 Jennifer Velasco 6/30/2006 Chloe Wilson 10/8/2007 Melody Zacarias 5/17/2007 Hazel Zamora 1/27/2007 Kayden Alexander 2/6/2006 Yvette Alvarado 3/30/2006 Damian Delaney 6/26/1961 Kimberly Amezcua 7/14/2006 Kimberly Antonio 5/30/2006 Alicia Aquino 6/15/2006 Samantha Aquino 6/27/2006 Destiny Arauz 6/13/2006 Julissa Arroyo 5/26/2006 Cassandra Ayala 8/18/2006 Samantha Ayala 7/2/2006 Eva Azul 2/6/2006 Stacey Bacelis 4/4/2006 America Baires 7/17/2006 Ashley Barajas 6/10/2005 Janet Barrera 10/14/2005 Alisa Benitez 5/26/2006 Sara Bolanos-Mejia 1/12/2006 Ashley Mendez 6/22/2006 Ana Carvente 7/12/2006 Mia Castellanos 6/19/2006 Rosalma Cebreros 3/3/2006 Yosselin Celis 5/25/2005 Jacqueline Lucero 9/2/1974 Evelyn Chamu 1/30/2006 Nataly Chavez 2/27/2006 Juliana Coeto 10/4/2005 Shesith Covarrubias 12/8/2005 Ashley Cruz 7/20/2006 Erin Dakers 8/2/2007 Claudia Lopez 6/16/2007 Cristina Diaz 10/13/2005 Zoe Dighero 4/11/2006 Kaylynn Domingo 10/4/2006 Celeste Dominguez 6/1/2006 Lizzy Escobar 12/14/2005 Lilian Escorza 12/23/2005

REGISTRATION

First Name Last Name DoB Jacqueline Lucero 9/2/1974 Ashley Mendez 6/22/2006 Hyobe Namkoong 6/19/2007 Hetzabel Sanchez 4/13/2005 cristal solis 9/29/2006 Briseida Lopez 5/22/2005 Daiman Johnson 3/3/1968 Kayleen Vasquez 12/9/2003 Ashley Aguilar 12/9/2003 Damian Delaney 6/26/1961 Michelle Dominguez 5/15/2005 Martha Bustos 1/12/1960 Jaqueline Granadino 9/6/2004 jacqueline granadino 9/6/2004 Jacqueline granadino 9/6/2004 Maria Gutierrez 11/30/2006 Claudia Lopez 6/16/2007 Kelly Benitez 9/14/1993 Kelly Benitez 9/14/1993

RESULT

First Name Last Name DoB Start Code Jacqueline Lucero 9/2/1974 1980001 Ashley Mendez 6/22/2006 1980002 Cristal Solis 9/29/2006 1980003 Daiman Johnson 3/3/1968 1980004 Damian Delaney 6/26/1961 1980005 Michelle Dominguez 5/15/2005 1980006 Martha Bustos 1/12/1960 1980007 Claudia Lopez 6/16/2007 1980008 Kelly Benitez 9/14/1993 1980009

Sample Data Sheet my problem is that my script sometimes getting run-time timeout. I am seeing map function but I'm not sure if it's applicable for my current problem.

here are my sheets that is included in my script. sheets are roster, form responses 1, reference, result. roster and registration tab have common columns (First name, Last Name, Date of Birth)

...

I am trying to run a docker-compose app that has two services. One to build a web server and the other to run the tests on it.

docker-compose.yml

...

this post is similar to this: Remove rows from pandas dataframe if string has 'only numbers'

But my difference is that there are rows that contains numbers (e.g. 3.3.2 etc). I want to be able to remove the rows but I am not sure if they are classified as float or string.

Sample data frame:

ID Column 1 3.3.4 texts here 2 3.3.4 3 3.3

Desired data frame after removal of rows:

ID Column 1 3.3.4 texts here

Thank you so much in advance.

Dictionary records: [{'Name': 'Rural-Lands-Strategy-Final-v2', 'Folder Location': 'Files\\Cootamundra-Gundagai', 'Coded Text': 'Action 3.3. On farm trials Allow for trials of small scale agriculture without development consent provided environmental and amenity impacts do not give rise for concern for Council and other agencies. The scale and timeframe must also be agreed to in writing. These uses and circumstances would need to be listed in Schedule 2 of the LEP.', 'Document Title': 'Rural Lands Strategy', 'Council Name': 'Cootamundra-Gundagai', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Economic Development', 'Topic': 'Local food producers'}, {'Name': 'The_Hills_Shire_Council_Annual_Report_2018_-2019', 'Folder Location': 'Files\\The Hills Shire', 'Coded Text': 'We embed sustainability principles into all areas of our work. This includes sustainable planning, transport, design, food production,', 'Document Title': '2019 THE HILLS SHIRE COUNCIL \nANNUAL REPORT \n2018-19 1 THSC', 'Council Name': 'The Hills Shire', 'State': 'NSW', 'Type of council': 'Metropolitan', 'Domain': 'Sustainability and environment', 'Topic': 'Sustainable food production'}, {'Name': 'TSC10479_Statutory_Annual_Report_2018_2019', 'Folder Location': 'Files\\Tweed', 'Coded Text': 'Home Expo \nIn September 2018, more than 600 people attended the sixth annual Tweed Shire Sustainable Living Home Expo held at Kingscliff TAFE. \nNinety per cent of attendees who were surveyed at the expo identified actions they intended to take following the event to improve sustainability at home. Planned actions included steps to reduce waste, increase energy efficiency, improve biodiversity, grow backyard food gardens and save water. At the expo, Mayor of Tweed, Katie Milne launched a $60,000 Tweed Shire Innovative Solutions Grants Program to encourage and support individuals, businesses, schools, organisations and community groups to develop innovative solutions to a range of sustainability challenges in the Tweed. On 16 September 2018, Sustainable House Day was held across Australia, and for the first time, the event included an open house in the Tweed. More than 100 people visited Elwood Farm in Limpinwood to marvel at the sustainable features home designers and owners Len and Robyn incorporated into their sustainable dream home.', 'Document Title': 'Annual Report 2018–2019', 'Council Name': 'Tweed', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Health and wellbeing - Education campaigns and events', 'Topic': 'Festivals with interactive education'}, {'Name': 'Brewarrina Child Care Centre policies', 'Folder Location': 'Files\\Brewarrina', 'Coded Text': 'educate children about diversity eg different skin colours, different abilities, different foods', 'Document Title': 'Brewarrina Child Care Centre', 'Council Name': 'Brewarrina', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Health and wellbeing - Education campaigns and events', 'Topic': 'School and childcare settings'}, {'Name': 'Annual-Report-201819_Byron', 'Folder Location': 'Files\\Byron', 'Coded Text': 'Refill Here Drinking Fountain Program', 'Document Title': 'Annual Report', 'Council Name': 'Byron', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Health and wellbeing', 'Topic': 'Drinking water access'}, {'Name': 'housing-strategy_Sutherland', 'Folder Location': 'Files\\Sutherland Shire', 'Coded Text': 'Sutherland centre is an appropriate location to increase residential density so that more people can benefit from being within walking distance to the station, shops and services. Sutherland is already a favoured housing choice for young people as it is a relatively affordable location that offers excellent public transport to jobs in the city. The housing strategy aims to further increase the number of small dwellings in the centre.', 'Document Title': 'HOUSING STRATEGY', 'Council Name': 'Sutherland Shire', 'State': 'NSW', 'Type of council': 'Metropolitan', 'Domain': 'Social and housing policy', 'Topic': 'Affordable housing'}, {'Name': 'mwrc-adopted-operational-plan-2019-20-sm', 'Folder Location': 'Files\\Mid-Western Regional', 'Coded Text': 'TIMEFRAME RESPONSIBILITY 30/06/2021 Review and release land for development as required Suitable land available 30/06/2020 Strategic Planning 30/06/2020 Strategic Planning 30/06/2020', 'Document Title': 'DELIVERY PROGRAM 2017/18 – 2020/21 OPERATIONAL PLAN 2019/20', 'Council Name': 'Mid-Western Regional', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Social and housing policy', 'Topic': 'Affordable housing'}, {'Name': 'Delivery_Program_2018-2021_Jan_2019v2', 'Folder Location': 'Files\\North Sydney', 'Coded Text': 'Support community in the development of community gardens, rooftop and hard surface greening', 'Document Title': 'DELIVERY PROGRAM 2018/19-2020/21', 'Council Name': 'North Sydney', 'State': 'NSW', 'Type of council': 'Metropolitan', 'Domain': 'Sustainability and environment', 'Topic': 'Food gardening'}, {'Name': 'Economic Development Plan PDF - 2015-2020_0', 'Folder Location': 'Files\\Bellingen', 'Coded Text': 'Participate in the Annual Mid North Coast Food Forum in partnership with other LGAs to enhance Industry development and commercial opportunities', 'Document Title': 'Economic Development and Tourism Plan 2015 - 2020', 'Council Name': 'Bellingen', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Economic Development', 'Topic': 'Local food initiatives'}, {'Name': 'QPRC_Tourism_Plan-_2017-2025', 'Folder Location': 'Files\\Queanbeyan-Palerang', 'Coded Text': 'Work with local wineries and produce suppliers to increase the presence and promotion of local wines and seasonal produce available in restaurants and cafes within the region and in Canberra', 'Document Title': 'QUEANBEYAN-PALERANG REGIONAL COUNCIL \nTOURISM PLAN 2017–2025: Supporting the Visitor Economy', 'Council Name': 'Queanbeyan-Palerang', 'State': 'NSW', 'Type of council': 'Regional', 'Domain': 'Sustainability and environment', 'Topic': 'Food chain connections'}]

...

I'm newbie with D3 and I trying to create a Scatterplot graphic. When I try to create the points in the graphics this don't appear correctly.

I've got 9 points to put in the scatterplot but only appears 5. And all of these are not located correctly in their positions. For example, we've got one in (0, 0) and is over the x = 0 correctly but the position in the y axis is not 0 is almost 2.

The data of all points are:

...