jennifer | Jennifer is a code generator for Go | Generator Utils library

I have an excel sheet with a large table with 3 main columns (Forward, Reverse and Species). I need to count distinct species for each pair from Forward and Reverse columns but I can't seem to make it work. I've tried going around it but the closest thing I found was this: "=SUM(IF(("Jennifer"=$D$6:$D$27)*($B$6:$B$27<=DATE(2011, 1, 31)), 1/COUNTIFS($D$6:$D$27, "Jennifer", $E$6:$E$27, $E$6:$E$27, $B$6:$B$27, "<="&DATE(2011, 1, 31))), 0))", which comes from this website https://www.get-digital-help.com/count-unique-distinct-values-that-meet-multiple-criteria-in-excel/ . Still, it doesn't work when I apply it to my sheet. I'm a complete newbe with excel so I'm looking for some help please. I'll drop a print of the sheet as well. Thanks in advance.

...

Description

I am trying to migrate data from a Pandas DataFrame to a MySQL database table but that data has some inconsistencies that I want to work around though I have not yet figured out a way to. Any help in figuring this out will be very much appreciated.

Example of the data I have:

user_type (table)

code detail a Secretary b Accountant

user_df (DataFrame with the data I want to migrate to the user table)

id name user_type_code (FK: user_type) 1 Jane Doe a 2 John Doe a 3 James Doe b 4 Jeff Doe c 5 Jennifer Doe d

As you can notice from the above data, the user_type_code with values c & d cannot be found in the user_type table.

What I want to achieve is to automatically insert those user_type missing data with dummy information to accommodate for the need of being corrected in the future and keep all the user records.

user_type table (how I want it to be at the end)

code detail a Secretary b Accountant c Unknown c d Unknown d

My Current Implementation ...

I have a list of names from different sources in one data set: one set is organized by FirstName LastName; the other has FullName. I want to see if the first name or the last name is within the full name column, and create a flag. Two questions:

First, I used this solution, but the resulting data doesn't have the right amount of rows, and I'm not sure how to get it to make a flag. I tried to turn it into an ifelse statement, but got another error. How do I fix this so if FirstName is in FullName, I flag True (or 1), otherwise I flag False (or 0)?

Second, I have a few million names, is this an efficient way to do things?

...

I recently started learning functional programming in Javascript, and one thing that's valued is Immutability. One way to preserve immutability is to when we want to modify some object that we first create a copy and then modify that copy and return it, for example:

...

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'm doing a search filter. I need to return the entire object containing the given actor by the user. I can find the actor, but I'm not sure how to return the object where the actor is.

JSON file:

...

This is my code so far

...

I've a DataTables which allow the user to search for custom column, all works well until the user reorder the columns. Infact I'm also using the ColumnReorder addon.

Essentially the index specified in the custom searching will change after the columns reorder, how can I fix this?

...