text:
import graphene

from .....attribute.models import AttributeValue
from .....attribute.utils import associate_attribute_values_to_instance
from .....tests.utils import dummy_editorjs
from ....tests.utils import get_graphql_content, get_graphql_content_from_response

PAGE_QUERY = """
    query PageQuery($id: ID, $slug: String) {
        page(id: $id, slug: $slug) {
            id
            title
            slug
            pageType {
                id
            }
            content
            contentJson
            attributes {
                attribute {
                    slug
                }
                values {
                    id
                    slug
                }
            }
        }
    }
"""

def test_query_published_page(user_api_client, page):
    page.is_published = True
    page.save()

    page_type = page.page_type

    assert page.attributes.count() == 1
    page_attr_assigned = page.attributes.first()
    page_attr = page_attr_assigned.attribute

    assert page_attr_assigned.values.count() == 1
    page_attr_value = page_attr_assigned.values.first()

    # query by ID
    variables = {"id": graphene.Node.to_global_id("Page", page.id)}
    response = user_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content(response)
    page_data = content["data"]["page"]
    assert (
        page_data["content"]
        == page_data["contentJson"]
        == dummy_editorjs("Test content.", True)
    )
    assert page_data["title"] == page.title
    assert page_data["slug"] == page.slug
    assert page_data["pageType"]["id"] == graphene.Node.to_global_id(
        "PageType", page.page_type.pk
    )

    expected_attributes = []
    for attr in page_type.page_attributes.all():
        values = (
            [
                {
                    "slug": page_attr_value.slug,
                    "id": graphene.Node.to_global_id(
                        "AttributeValue", page_attr_value.pk
                    ),
                }
            ]
            if attr.slug == page_attr.slug
            else []
        )
        expected_attributes.append({"attribute": {"slug": attr.slug}, "values": values})

    for attr_data in page_data["attributes"]:
        assert attr_data in expected_attributes

    # query by slug
    variables = {"slug": page.slug}
    response = user_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content(response)
    assert content["data"]["page"]["id"] == graphene.Node.to_global_id("Page", page.id)

def test_customer_query_unpublished_page(user_api_client, page):
    page.is_published = False
    page.save()

    # query by ID
    variables = {"id": graphene.Node.to_global_id("Page", page.id)}
    response = user_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content(response)
    assert content["data"]["page"] is None

    # query by slug
    variables = {"slug": page.slug}
    response = user_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content(response)
    assert content["data"]["page"] is None

def test_staff_query_unpublished_page_by_id(
    staff_api_client, page, permission_manage_pages
):
    page.is_published = False
    page.save()

    # query by ID
    variables = {"id": graphene.Node.to_global_id("Page", page.id)}
    response = staff_api_client.post_graphql(
        PAGE_QUERY,
        variables,
        permissions=[permission_manage_pages],
        check_no_permissions=False,
    )
    content = get_graphql_content(response)
    assert content["data"]["page"]["id"] == variables["id"]

def test_staff_query_unpublished_page_by_id_without_required_permission(
    staff_api_client,
    page,
):
    page.is_published = False
    page.save()

    # query by ID
    variables = {"id": graphene.Node.to_global_id("Page", page.id)}
    response = staff_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content(response)
    assert content["data"]["page"] is None

def test_app_query_unpublished_page_by_id(
    app_api_client, page, permission_manage_pages
):
    # given
    page.is_published = False
    page.save()

    app_api_client.app.permissions.add(permission_manage_pages)

    variables = {"id": graphene.Node.to_global_id("Page", page.id)}

    # when
    response = app_api_client.post_graphql(
        PAGE_QUERY,
        variables,
    )

    # then
    content = get_graphql_content(response)
    assert content["data"]["page"]["id"] == variables["id"]

def test_app_query_unpublished_page_by_id_without_required_permission(
    app_api_client,
    page,
):
    # given
    page.is_published = False
    page.save()

    variables = {"id": graphene.Node.to_global_id("Page", page.id)}

    # when
    response = app_api_client.post_graphql(PAGE_QUERY, variables)

    # then
    content = get_graphql_content(response)
    assert content["data"]["page"] is None

def test_app_query_unpublished_page_by_slug(
    app_api_client, page, permission_manage_pages
):
    # given
    page.is_published = False
    page.save()

    app_api_client.app.permissions.add(permission_manage_pages)

    variables = {"slug": page.slug}

    # when
    response = app_api_client.post_graphql(
        PAGE_QUERY,
        variables,
    )

    # then
    content = get_graphql_content(response)
    assert content["data"]["page"]["id"] == graphene.Node.to_global_id("Page", page.id)

def test_app_query_unpublished_page_by_slug_without_required_permission(
    app_api_client,
    page,
):
    # given
    page.is_published = False
    page.save()

    # when
    variables = {"slug": page.slug}

    # then
    response = app_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content(response)
    assert content["data"]["page"] is None

def test_staff_query_unpublished_page_by_slug(
    staff_api_client, page, permission_manage_pages
):
    page.is_published = False
    page.save()

    # query by slug
    variables = {"slug": page.slug}
    response = staff_api_client.post_graphql(
        PAGE_QUERY,
        variables,
        permissions=[permission_manage_pages],
        check_no_permissions=False,
    )
    content = get_graphql_content(response)
    assert content["data"]["page"]["id"] == graphene.Node.to_global_id("Page", page.id)

def test_staff_query_unpublished_page_by_slug_without_required_permission(
    staff_api_client,
    page,
):
    page.is_published = False
    page.save()

    # query by slug
    variables = {"slug": page.slug}
    response = staff_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content(response)
    assert content["data"]["page"] is None

def test_staff_query_page_by_invalid_id(staff_api_client, page):
    id = "bh/"
    variables = {"id": id}
    response = staff_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content_from_response(response)
    assert len(content["errors"]) == 1
    assert content["errors"][0]["message"] == f"Couldn't resolve id: {id}."
    assert content["data"]["page"] is None

def test_staff_query_page_with_invalid_object_type(staff_api_client, page):
    variables = {"id": graphene.Node.to_global_id("Order", page.id)}
    response = staff_api_client.post_graphql(PAGE_QUERY, variables)
    content = get_graphql_content(response)
    assert content["data"]["page"] is None

def test_get_page_with_sorted_attribute_values(
    staff_api_client,
    page,
    product_list,
    page_type_product_reference_attribute,
    permission_manage_pages,
):
    # given
    page_type = page.page_type
    page_type.page_attributes.set([page_type_product_reference_attribute])

    attr_value_1 = AttributeValue.objects.create(
        attribute=page_type_product_reference_attribute,
        name=product_list[0].name,
        slug=f"{page.pk}_{product_list[0].pk}",
    )
    attr_value_2 = AttributeValue.objects.create(
        attribute=page_type_product_reference_attribute,
        name=product_list[1].name,
        slug=f"{page.pk}_{product_list[1].pk}",
    )
    attr_value_3 = AttributeValue.objects.create(
        attribute=page_type_product_reference_attribute,
        name=product_list[2].name,
        slug=f"{page.pk}_{product_list[2].pk}",
    )

    attr_values = [attr_value_2, attr_value_1, attr_value_3]
    associate_attribute_values_to_instance(
        page, page_type_product_reference_attribute, *attr_values
    )

    page_id = graphene.Node.to_global_id("Page", page.id)
    variables = {"id": page_id}
    staff_api_client.user.user_permissions.add(permission_manage_pages)

    # when
    response = staff_api_client.post_graphql(PAGE_QUERY, variables)

    # then
    content = get_graphql_content(response)
    data = content["data"]["page"]
    assert len(data["attributes"]) == 1
    values = data["attributes"][0]["values"]
    assert len(values) == 3
    assert [value["id"] for value in values] == [
        graphene.Node.to_global_id("AttributeValue", val.pk) for val in attr_values
    ]

redpajama_set_name: RedPajamaGithub


Hey, young bloods! Today I'm linking up with Cait and Sky to bring you Beautiful People, where you answer questions about your book characters in an effort to get to know them better. This month is a special parental addition in honor of Mother's Day, and I'll be introducing Linus, Alizabeth, and Elosius.
Alizabeth and Elosius are the Empress and Emperor of Cavanor in my high fantasy series Death of the Skies. Linus is their son, a reclusive, cynical, and bookish 16 year old.
1. Overall, how good is their relationship with her parents?
It's.....not bad? Linus is pretty independent and reclusive, but since he's an only child, his parents tend to hover around him. As a result, he drifts away even more. So he's not close to them, but he doesn't particularly dislike them.
2. Do they know both their biological parents?
Elosius was the prince at the time, and he needed to find a suitable wife. Alizabeth, a young noblewoman who'd recently moved back to the city after three years spent in the country for her father's health, caught his eye and stole his heart. They met at a banquet, courted for a few months, and were married. Their relationship is rather unique in that although their marriage was a perfect political move, they are still very fond of each other.
4. How would your character feel if they were told, "you're turning out like your parents"?
Linus would be pretty ambivalent. His parents are good political strategists, so he wouldn't mind being compared to them. However, he wouldn't be thrilled. He wants to be more than his parents - more powerful, more brilliant, more dangerous. More.
5. What were your character's parents doing when they were your character's age?
Aside from dealing with crime lords and uncovering royal plots, Elosius was doing much the same thing as Linus. The same sorts of lessons, the same sorts of training, the same sorts of responsibilities. Alizabeth would have recently left the overcrowded capital, Galhorn, for the refreshing countryside.
Linus wants to stay in Galhorn. However, his parents want to send him away for his safety since there are rumors of a plot for his head.
7. What did your parents find hardest about raising your character?
Well, being Emperor and Empress, they didn't have time to do a lot of raising. Linus was mainly brought up by his servants and the royal librarian, Tertio. As a result, he's always been super independent from his parents and, though he doesn't disrespect them, he still sees little point in deference purely because they birthed him. Whenever they try to interact with him, his distance and lack of deference frustrate them to no end.
8. What's their most vivid memory of their parental figure(s)?
Alizabeth and Elosius may be Linus's parents, but Tertio has always been much more of a parental figure. Linus's most vivid memory with Tertio is of one day when he was eight. Tertio was sitting Linus that day, and he brought him back into the maze of library rooms only open to librarians and scholars. Linus was completely enchanted. It was the day that ignited his love for learning, researching, and always looking for new answers.
Lots of people were involved in raising Linus, so he never developed a super strong connection to any one of them. Thus, he was reclusive even as a toddler. He often went off only with his toy soldiers to run around outside and hide in trees and under plants. He liked playing hide and seek in the huge Castle and its enormous gardens.
10. Why and how did your parents choose your character's name?
Linus Afhildor Gaelmorond Galatius Aradassian is Linus's full name. Linus is after Alizabeth's father, Gaelmorond and Galatius are traditional royalty names (like Henry or Charles in England), and Afhildor is the male version of Afhildora, the Patron Priestess of Power.
Let's chat! Who are your favorite bookish parents? Do you know why your name was chosen? Are you participating in Beautiful People? Comment below, and remember that you are all very beautiful pickles.
I love that he considers the librarian as more of a parental figure than his actual parents. I would have been enchanted by the library rooms too.
Ahhhh, oh my god THANK YOU SO MUCH!
Wowza, you've really put a lot of effort into this! Linus seems like a very intriguing character, and one I'd definitely love to learn more about.


The Beauty Scoop!: Free Murad Facial Worth Up To £50 in Today's Telegraph!
Free Murad Facial Worth Up To £50 in Today's Telegraph!
"The Telegraph has teamed up with America's number one skincare brand Murad to give you the chance to experience the Youthful You facial and get gorgeous, glowing skin for free.
Founded by renowned dermatologist, Dr Howard Murad, the range of professional facial treatments and skincare products is results driven and targeted to all skin types. Murad is beloved by A-listers on both sides of the Atlantic including Kim Cattrall, Kristin Davis, Fearne Cotton and Holly Willoughby.
Dr Murad designed the Youthful You facial to visibly reduce the appearance of lines and wrinkles and is his alternative to invasive anti-ageing procedures. The intensive resurfacing treatment uses the power of glycolic acid and pomegranate fruit to give maximum exfoliation, encouraging cell turnover, hydration and pumping skin full of antioxidants and anti-inflammatories . Skin will be clearer, lines smoothed so you can glow with health and radiance. Murad facials and skincare products are available in spas and salons nationwide. Visit www.murad.co.uk for more information.
I think this looks like a great deal and hopefully will be able to pick up a paper today whilst out... will you be buying the paper too?
ooh, sounds brill! might get my mum to get the paper and it's probs better for her, as i'm not in much need of 'youth' on my face quite yet! lol. thanks for that!


At the beginning of 2017 I posted my yearly goals. One of which was to hit 1,000 followers on Instagram. I thought it would take me the whole year to get to that goal but I was wrong. Hard work pays of off. This post is long overdue, but I just want to say THANK YOU to everyone who has followed me and helped this goal become a reality before we hit the half way mark of this year. Instagram is one of my favorite social media sites because it is an easy way to stay connected with friends and other bloggers. I love seeing the photos of everyone and the new things they are trying, and it means so much that over 1,000 people keep up with me!
MY TIPS FOR OTHER BLOGGERS!
Disclaimer: Items in this post were gifted for promotion. All thoughts and opinions are mine and mine alone!
Spring is here and with a new season, new trends tend to show up. One of the most popular trends that I am seeing all over social media is the Cold Shoulder trend. Shirts, Dresses, Sweatshirts, every brand is hopping on this trend and I can see why, the style is super cute and super modest!


text:
Champions (Campeones)
Javier Gutiérrez, Sergio Olmos, Julio Fernández, Jesús Lago
Director of Photography: Chechu Graf
Editor: Javier Fesser
Produced by: Luis Manso, Álvaro Longoria, Javier Fesser, Gabriel Arias-Salgado
Music: Rafael Arnau
Screenplay by: David Marqués, Javier Fesser
Sound Production: Arman Ciudad, Charly Schmukler
Marco (Javier Gutiérrez), the assistant coach of a professional basketball team in Spain's First Division, has problems at work, problems with his wife and problems with almost everything. After a drunken brawl with the head coach leads to community service, Marco is sentenced to coach a basketball team of people with learning disabilities. Marco is surprised to find that he's the one with the most to gain from his adventure with the team, whose love of life and understanding of what's really important are lessons Marco has yet to learn. [15]
Champions is nominated for the 2019 EIFF Audience Award.
Javier Fesser is a storyteller in cinema, advertising campaigns, short films, TV programmes and miniseries for the internet. His feature films, including Mortadelo & Filemon: The Big Adventure, Camino and the animation Mortadelo and Filemon: Mission Implausible, have won multiple Goya Awards. His short film Binta and the Great Idea won awards in more than 100 festivals and was nominated for an Oscar in 2007.
Latido Films, Madrid, Spain
email: latido@latidofilms.com
web: www.latidofilms.com

redpajama_set_name: RedPajamaCommonCrawl


text:
Félix Carrasco-Córdova (born July 29, 1955) is a Mexican-Austrian conductor. He has performed successfully near a hundred different orchestras around the world and has gained international recognition for his extraordinary performances. His sensitivity and accurate interpretation of the score has impressed audiences. Some characteristics that critics have applauded are for sound, pitch and rapid response from the musicians.

Education

He studied Piano, Oboe, and Conducting in the National Conservatory of Music of Mexico until he received an opportunity to attend Vienna's famous Hochschule für Musik (University of Music and Performing Arts, Vienna) which he later received a full scholarship by the Austrian government for his successful studies. He studied with Karl Österreicher (conducting), Thomas Christian David (composition), Harald Goertz (opera conducting), and Guenther Theuring (choral conducting). He finished his studies and graduated in 1982 with Honors.

Conducting career

Throughout his career, Felix Carrasco has been the Artistic Director of several Austrian and Mexican orchestras.

1982–1990
The First Austrian Women's Chamber Orchestra (1982–1983), The Pro-Arte Orchestra in Vienna (1983–1985), The Querétaro Chamber Orchestra (1986–1988), and The Orchestra of the Manuel M. Ponce Cultural Society (1987). Additionally, he was Second Conductor of the Mexico City Philharmonic Orchestra from 1986 to 1990 under principal conductor Maestro Enrique Bátiz Campbell.

1991–2009

From 1991 to 2009 he was the Artistic Director and Principal Conductor of the Monterrey UANL Symphony Orchestra.  He transformed the Monterrey UANL Symphony Orchestra in one of the most prestigious orchestras in Mexico, considered by many guest artists to be worthy of international standards.

In 1997 he founded the Monterrey Chamber Orchestra.

Carrasco conducted more than forty concerts a year with the Monterrey UANL Symphony Orchestra, where he spent 19 years. He delighted and pleased his audiences with a vast repertoire of Baroque music, Classical period (music), Romantic music, and 20th-century classical music. His concerts included a vast repertoire of Chamber music, Symphony music, Opera and Oratorio. The city of Monterrey and its thousands of audience members were honored with the many premieres of classical masterpieces he offered.

Carrasco shared the stage with important soloists and singers such as: Lucia Aliberti, Mario Hossen, Antal Szalai, Jörg Demus, Carlos Prieto (cellist), Eva Maria Zuk, Otto Sauter, Joan Kwuon, Michael Werba, Carlos Bonell, Vadim Brodski, just to name a few.

He has been a passionate motivator, supporter and promoter of Mexican composers such as: Paulino Paredes Pérez, Silvino Jaramillo, Arturo Rodriguez, and Felipe Ledesma, amongst the few. In which he globally premiered many of their pieces.

In 2000 he formed The Pops season called "Conciertos en Mangas de Camisa", that played popular music (generally traditional pop) and show tunes as well as well-known classical works. Some of its music included: Movie themes, Eugenia Leon, The Symphonic Beatles with Vadim Brodski, Symphonic Rock Music, Symphonic Queen with Carlos Bonell, Glenn Miller, Agustín Lara, Perez Prado, Betsy Pecanins, Raúl di Blasio, Mariachi Vargas de Tecalitlán

Guest Conductor

Among the countries whose main orchestras he has guest conducted are:

Europe: Germany, Austria, Switzerland, Spain, Greece, Hungary, Italy, Latvia, Lithuania, Macedonia, Poland, Portugal, and The Czech Republic.

Africa and Asia: China, Cyprus, Egypt, Kazakhstan, Turkey and Taiwan.

Americas: Canada, Colombia, Cuba, the United States, Mexico, the Dominican Republic, and Venezuela.

Carrasco has also participated as a guest conductor for several international tours through Europe with the Hungarian National Philharmonic of Budapest, the Szeged Symphony Orchestra, both in Hungary, the Philharmonic Orchestra of Brasov, the Feminine Symphony of Austria, and the Chamber Orchestra of Tokyo.

For several years, Carrasco has been a permanent guest conductor to the Zurich Symphony Orchestra, the Polish Baltic Philharmonic, the Orquestra do Norte in Portugal, the Cairo Symphony Orchestra, and the Orquesta Sinfónica del Estado de México.

Professor

As a professor, he has taught orchestral conducting in three of the most important Mexican Universities: The Universidad Autónoma de Nuevo León, The Autonomous University of Coahuila, and The National Autonomous University of Mexico.

Accomplishments and awards

Transforming the Monterrey UANL Symphony Orchestra in one of the most prestigious orchestras in Mexico.

In 1995 The Universidad Autónoma de Nuevo León honored Carrasco with the Highest Arts Prize for his accomplishments with the Monterrey UANL Symphony Orchestra.

In 1997 the State of Nuevo León honored him with the Medal of Civic Achievement for his contribution to the cultural development of the State.

The Mexican government and the Austrian Embassy in Mexico awarded him with the Mozart's Gold Medal in 2002 Mozart Medal (Mexico), which has been granted only to the most distinguished figures of classical music in Mexico.

He was the first Mexican to perform within the walls of The Forbidden City in Beijing, China, with the Beijing Symphony Orchestra in 2005. His program included Mexican and international pieces.

Recordings

From 2002, several albums were recorded with the Monterrey UANL Symphony Orchestra:

Compositores de Nuevo León (Nuevo León Composers)
This compilation shows the talent of northeast Mexican composers (born or naturalized in this region), whose work was recently discovered and encouraged by Carrasco.

Compositores de Nuevo León Tríptico (Nuevo León Composers trilogy)
The album contains 3 CD's. It as a compilation from the first Nuevo León Composers cd with more pieces from northeast Mexican composers.

Obras Maestras para Jóvenes (Classical masterpieces for children)
Felix Carrasco is aware of the importance of early approach of classical music to children. This is why this project was entirely thought for them. Beautiful stories such as Peter and the Wolf (Prokofiev), Carnival of the Animals (Saint-Saëns), and The Young Person's Guide to the Orchestra (Britten) are included in this CD.

Obras de piano y orquesta (Piano and orchestra pieces)
This romantic CD includes famous scores for piano and orchestra of the American composer George Gershwin and the Mexican talent Manuel M. Ponce.

Cañón Huasteca (Huasteca Canyon)
The first album with works of Paulino Paredes. Paulino Paredes (1913–1957).

Muñecos de Barro (Clay Puppets)
A second album with the works of Paulino Paredes, tuning to a more ballet style classical music. Paulino Paredes (1913–1957).

External links

 Noticias Presidencia Gob Mex

 Rudin's cello a delight under Carrasco

1955 births
Living people
Mexican people of Irish descent
Academic staff of the Autonomous University of Nuevo León
Academic staff of the Autonomous University of Coahuila
Academic staff of the National Autonomous University of Mexico

redpajama_set_name: RedPajamaWikipedia


text:
Home Destinations SA voted Star All-Round Destination
SA voted Star All-Round Destination
South Africa was recently awarded the Star All-Round Destination accolade in the Travel Bulletin Star Awards 2017, one of the UK travel trade's most prestigious awards programme. South Africa was also a finalist in four other categories, including Star Adventure & Activity Holidays Destination and Star Cultural & Heritage Holidays Destination.
The Travel Bulletin Star Awards, now in their 21st year, cover every sector of the tourism industry, serving to recognise, reward and celebrate excellence by acknowledging the suppliers that provided the best products and services. The awards are voted for exclusively by UK high street multiple, independent, online and home-based travel agents, championing the companies and destinations they consider to be the very best.
South Africa's amazing offering was also recognised in several categories of the Condé Nast Traveller Readers' Travel Awards 2017 which celebrate the world's most incredible travel experiences. Readers are asked to rate their favourite countries, cities, islands, hotels, spas, airlines and tour operators against criteria such as service, design, culture and value for money to produce an overall satisfaction score out of 100.
In the Overseas Holiday Hotels category, Singita Sabi Sand was the winner in the Middle East, Africa & The Indian Ocean region. Ellerman House Cape Town, Londolozi Game Reserve, Belmond Mount Nelson Hotel Cape Town, Bushmans Kloof Wilderness Reserve & Wellness Retreat, One&Only Cape Town and Cape View Clifton Cape Town were also recognised amongst the top 20. In the Countries category, South Africa was awarded sixth place, while Cape Town was voted seventh in the Overseas Cities category.
South African Tourism Hub Head: UK & Ireland Tolene van Der Merwe says,
"We're absolutely delighted that South Africa's offering has been recognised by so many awards this week from the UK travel industry, key partners in the trade as well as holidaymakers themselves. It really underlines what a fantastic array of experiences our beautiful country has to offer. As we work towards contributing to achieving our 5 in 5 strategy of adding five million more arrivals to South Africa within the next five years, we're looking forward to continuing to put South Africa on every UK traveller's wish list in 2018 and beyond."
The UK is one of South Africa's most important source markets, between January and May 2017, South Africa welcomed 209, 891 tourist from the UK marking a 2.5% increase when compared to the same period last year.
Previous articleSANParks implements Quick Payment Portal
Next articleKwaZulu Natal bolsters rhino protection efforts


text:
Q: Python: concat rows of two dataframes where not all columns are the same I have two dataframes:
EDIT:
df1 = pd.DataFrame(index = [0,1,2], columns=['timestamp', 'order_id', 'account_id', 'USD', 'CAD'])
df1['timestamp']=['2022-01-01','2022-01-02','2022-01-03']
df1['account_id']=['usdcad','usdcad','usdcad']
df1['order_id']=['11233123','12313213','12341242']
df1['USD'] = [1,2,3]
df1['CAD'] = [4,5,6]
df1:
    timestamp   account_id order_id  USD CAD
0   2022-01-01  usdcad     11233123  1   4
1   2022-01-02  usdcad     12313213  2   5
2   2022-01-03  usdcad     12341242  3   6

df2 = pd.DataFrame(index = [0,1], columns = ['timestamp','account_id', 'currency','balance'])
df2['timestamp']=['2021-12-21','2021-12-21']
df2['account_id']=['usdcad','usdcad']
df2['currency'] = ['USD', 'CAD']
df2['balance'] = [2,3]
df2:
    timestamp  account_id currency  balance
0   2021-12-21 usdcad     USD       2
1   2021-12-21 usdcad     CAD       3

I would like to add a row to df1 at index 0, and fill that row with the balance of df2 based on currency. So the final df should look like this:
df:
    timestamp   account_id order_id  USD CAD
0   0           0          0         2   3
1   2022-01-01  usdcad     11233123  1   4
2   2022-01-02  usdcad     12313213  2   5
3   2022-01-03  usdcad     12341242  3   6

How can I do this in a pythonic way? Thank you

A: Set the index of df2 to currency then transpose the index to columns, then append this dataframe with df1
df_out = df2.set_index('currency').T.append(df1, ignore_index=True).fillna(0)

print(df_out)

   USD  CAD  order_id
0    2    3         0
1    1    4  11233123
2    2    5  12313213
3    3    6  12341242

redpajama_set_name: RedPajamaStackExchange


text:
< < Back
UTET 2021 Notification, Exam Dates, Admit Card, Exam Pattern, Counselling
Uttarakhand Teacher Eligibility Test 2021
Admission Over
Download Subscribe to This Exam
Conducting Body
Examination Details
Day/Days of Exam
Counseling Details
UTET 2021 Exam - Dates, Registration, Eligibility, Syllabus, Exam Pattern
Uttarakhand Teacher Eligibility Test 2021 or UTET 2021 is the entrance examination for admission to TET. UTET 2021 is conducted by Uttarakhand Board of School Education.
UTET for the year 2021 has been announced by Uttarakhand Board of School Education and will be held on 26/11/2021. The application forms will be available from 01/09/2021 till 04/10/2021. The exam is in written mode. The duration of the exam will be 150 minutes. It is being conducted in English and Hindi languages. Admit card will be available from 09/11/2021. The result date will be announced later.
For Course(s)
To get all details about UTET 2021 Download Brochure
Subscribe to This Exam
UTET 2021 Conducting Body
Uttarakhand Board of School Education
UTET 2021 Eligibility Criteria
Educational Qualifications: The Minimum Academic Qualifications for UTET 2021 required are
(I-V) (UTET-I)
Higher Secondary (or its equivalent) and Elementary Education with at least 50% marks Two Year Diploma in (D.L.Ed./B.T.C.)
In Higher Secondary (or its equivalent) and Elementary Education with at least 45% marks Two Year Diploma (D.L.Ed./B.T.C.), which is recognized by the National Council for Teacher Education (Recognition, Standards and Procedure) Regulations 2002.
Higher Secondary (or its equivalent) with at least 50% marks and 4 years of elementary education Bachelor in Science (B.L.Ed.).
Higher Secondary (or its equivalent) and Pedagogy (Special Education) with at least 50% marks Two Year Diploma.
Graduation (or its equivalent) and 2-year Diploma in Elementary Education (D.L.Ed./B.T.C.).
Graduation with minimum 50% marks and Bachelor of Education (B.Ed.)
Such Shikshamitras working on honorarium in government primary schools, who have helped the state government After permission, two years D.L.Ed. from Indira Gandhi National Open University (IV) have passed the training.
(VI-VIII) (UTET-II)
Graduation (or its equivalent) and 2-year Diploma in Elementary Education (B.T.C./D.L.Ed.) Passed.
Graduation (or its equivalent) with minimum 50% marks and Bachelor of Education B.Ed./L.T./Shiksha Shastri (Institutional only) Passed.
Graduation (or its equivalent) with at least 45% marks and Bachelor of Pedagogy B.Ed./L.T./Shiksha Shastri (Institutional only) issued from time to time in this regard Obtained as per National Council for Teacher Education (Recognition, Norms and Procedure) Regulations.
Higher Secondary (or its equivalent) with at least 50% marks and 4-year Elementary Bachelor in Education (B.L.Ed).
Higher Secondary (or its equivalent) with minimum 50% marks and 4 years B.A./B.Sc.Ed. or B.A.Ed./B.Sc.Ed.
Graduation (or its equivalent) with at least 50% marks and Rehabilitation Council of India (ii) Passed B.Ed (Special Education) recognized
Graduation or Post Graduation with minimum 50% marks and passed B.Ed, provided that Graduation The condition of minimum percentage of marks at the level will not be applicable in the case of incumbents who have completed their education. Graduation in Elementary Education or equivalent course should be enrolled before 29th July 2011 Had taken.
UTET 2021 Important Dates
01/09/2021 30/09/2021 05:00 pm
Application Form With Late Fee
- 04/10/2021 11:55 pm
Admit Card Release Date
UTET 2021 Exam Date
Offline Dates
Answer Key For Challenge Display
UTET 2021 Prospectus
Link: View/Download
UTET 2021 Date and Time
(UTET-I) 26-11-2021 100:00 am to 12:30 pm
(UTET-II) 26-11-2021 02:00 pm tp 04:30 pm
UTET 2021 Application Form
Application Form Filling Instructions
Students applying for the UTET 2021 have to fill up the application form on the official site.
The student can submit the application only once. Multiple forms will be rejected.
The submission is ONLINE only.
Requirements to be readied before you start filling up the Application Form of UTET 2021
PC or a Laptop with Internet connectivity
Qualification details
Soft copy of candidate's coloured passport size photograph (Maximum 10kb / 100KB in size) in JPG / JPEG format with White Background.
Soft copy of candidate's signature (Maximum 05kb / 100 KB in size) in JPG / JPEG format.
Functional e-mail Id as all communication are made through email; Parents email id is recommended.
Mobile number as all information is sent through SMS too. Parents phone number can be used.
For online payments, usually a valid debit or credit card as well as Net Banking facility, Credit Cards & Debit Cards Service is a must.
Printer is required for keeping hard copies; if there is no printer, one can save the printouts, transfer them on to a pen drive and get it printed from a cyber-café.
It is recommended to download the information Bulletin Brochure and read it carefully so that you understand various requirements to fill up the form.
The Usual Steps in filling up the Online Application Form of the UTET 2021
Step-1: Students have to register for Online Application Form. A login and Password are created.
Step-2: Student has to Complete the Application Form and its various sections
Step-3: Required documents in the form of Scanned Images of Candidate's Photograph, Candidate's Signature and Left Thumb Impression.
Step-4: Payments have to be made by Net Banking, Credit Cards, Debit Cards & Demand Draft
UTET 2021 Exam Pattern
Exam Mode
Offline Exam
Exam Type
Duration (in Minutes)
UTET 2021 Admit Card
Admit Card Download Start Date
Admit Card Download Url
UTET 2021 Exam Day Instructions
Examination Day Instructions
Before entering the Exam Centre
Try to reach the exam centre one hour prior to the time advised in the admit card.
Before leaving for the site, please have a hearty breakfast or light lunch depending on the session. Drink plenty of fluids; as in summers dehydration can set in affecting your performance in the exam.
Have a cookie or a chocolate just before entering the centre; this prevents hypoglycaemia and thus helps you stay alert longer improving your results.
If it is a busy centre, then don't wait till last for the entry and security check.
Centre will not allow you to enter after the stipulated time of closing the doors.
Admission to the Exam Centre is with the Admit Card; no candidates shall be admitted to the test without the production of the Admit Card at the Test Centre.
Usually no bags are allowed.
No eatables are allowed.
No communication equipment such as mobile phones / pager / wireless set / scanner / camera or any such electronic / digital gadget etc are allowed in the exam centre; carrying one will lead to disqualification.
After entering the centre
Once candidates enter the centre, they should locate their designated hall and seat.
After all the formalities, candidates should enter the allotted hall and take the designated seat.
For Objective Type question papers, rough work is to be done in the space provided for this purpose. No rough work is allowed on the OMR Answer Sheet under any situation.
Questions have to be answered on the answer sheet only.
Copying, use of unfair means of any kind, talking, asking questions from other candidates or borrowing of material inside the Test Centre is strictly prohibited.
The candidates are to return their OMR answer-sheets and the question paper in full to the Centre Superintendent. Tearing or taking away of the question paper is not allowed failing which the candidates shall be disqualified from the entire Entrance Test.
Misbehaviour of any kind can lead to expulsion of the candidate.
Caught copying helping in copying will mean cancellation of the answer sheet / cancellation of the candidature.
Marking the answer sheet or question paper in any way will also lead to cancellation of the exam for that candidate.
UTET 2021 Results
Result URL
Check your result here
HP TET November 2022
KTET February 2022
HP TET 2022
HTET 2021
KTET May 2021
Assam TET 2021
Meghalaya TET 2021
Tripura TET 2021
Related Notifications View All
Counselling details will be added when they are announced.


source of experiences but as living, participatory reality.
The methods are introduced step by step, with feedback and reflection, so that they are always directly applicable and alive for the experienced and for newcomers alike. Some of the methods are individual exercises, others are practices for groups of various sizes. Some explore a general opening into moving awareness, others go in through specific approaches such as "moving and being moved", "self-consciousness" or "habits in the body". We are currently finishing a book describing 50 Moving Meditation practices. Four of them are already available as CD's / sound files with guided meditations (see the page PUBLICATIONS).
"dancing with what is". Not a particular kind of experience or being.
Philosophical process is integral to Moving Meditation. Not as academic lectures and fixed frameworks, but as living and shared listening and reflection in fresh experience. It is true of all kinds of meditation that this helps cultivate a layer of meditative insight and stabilization of benefits. But it is particularly vital in Moving Meditation bevause we tend to have particularly narrow understandings of the ways our bodies shape our lives – or indeed ARE our lives.
Our sources and inspirations in developing Moving Meditation have been many. It is as if a cluster of practices and insights in the spirit of our time came together on their own initiative and invited us to play along. Particularly important inspirations are Buddhist wisdom traditions (particularly dzogchen, via Chögyam Trungpa and Tulku Urgyen Rinpoche's heirs), the Osho tradition (via Michael Barnett), the recent wave of mindfulness meditation (Jon Kabat-Zinn and others) and a ramified contemporary of culture in body and movement (Feldenkrais, Five Rhythms, Authentic Movement and many other expressions). We very clearly cannot be said to have invented anything that was not already happening, it is more that we go along with somthing that the spirit of the time is cooking. Perhaps one can say that we do this thoroughly with 100% embodiment and 100% meditation where many of the great sources of inspiration tend to be 100% in one of the sides with some more partial openings to the other side.
We are also deeply inspired by several philosophical openings into process thought, systems thought and philosophy of organism, evolution, relationality and aesthetics (Goethe, Whitehead, Bergson, Bateson, Varela) – but again, this is as modes of practical work and explorative dialogue rather than fixed systems of thought.
Finally we would like to mention that the work of Moving Meditation is very much nourished by a third stream of culture beside the two obvious ones, East and West. The embodied energy of groovy rhythms is essential to much of the practice of Moving Meditation. So rather than the classical idea of East-meets-West we ought perhaps, just because the living moving body is so very essential, we should perhaps speak of the meeting of three currents, East, West and South.


Kasongo's story could have ended with her wandering the streets of Kikula with her siblings, desperately trying to survive. With no means of supporting herself, Kasongo began to suffer physically from a lack of food. The trauma of her father dying and the rejection of her mother abandoning her have left deep scars in this young girl.
Care Workers are the men and women from local churches who have committed their lives to caring for vulnerable and traumatised children. But many of them have suffered their own traumatic experiences of abuse and abandonment. Though many Care Workers desire to provide holistic care for the most vulnerable children in their community, often the pain within their own hearts affects their ability to give.
Madeline* is a 10-year-old girl living in Chilabula, a small village 30 kilometres from the town of Luanshya in Zambia. Madeline is now in grade 2 and enjoys going to school. One day, she hopes to become a nurse so she can help people in need. When she is not at school, she enjoys playing games and collecting wild fruits with her friends.
At Hands at Work we have many volunteers, from Africa and all over the world, who have had experiences in Africa that have changed their lives. Most volunteers have a moment, or a series of moments that defined their understanding of God's heart for the poor. At Hands we encourage all volunteers to focus on relationships, and the real moments God blesses them with as they meet Care Workers and children across Africa. Often these moments become a memory, but sometimes they are captured on camera. Photos have a powerful way of evoking memories and the feelings experienced in the moment. We asked our volunteers for one photo that is really significant to them and to describe why. The most significant photos to us are not always necessarily the most professional or even most beautiful images. They are the ones, however, that take us back to a moment that changed our lives.
"Nothing to live for herself but so much to give for others"
"She does not need words to head the CBO"
In the end, being strict with myself, I have today decided to select one from this past visit to KaPhunga.
It's one that reminds me of lots of things ~ the new centre can be seen in the background ~ there is wonderfully caring baba Vusi, who shows such love to every child and family he meets ~ including this little family that we met on our way back from visiting the 'field' that Nomsa (Community Based Organisation Coordinator) has been given by the community to grow maize for the children of Swaziland. It shows me how Hands at Work has assisted Nomsa to encourage a community in her country to care for the widows and orphans, and bringing us all together from all around the world, walking side by side to be the hands, feet and heart of Jesus.
Annie is a disabled teenaged girl who lives with incredible challenges. Orphaned, neglected and rejected, her incredible smile encourages me to hang on to hope in hopeless situations and trust God for breakthroughs.
The reason I love this photo: it represents the unity of working together and the main source of the day; food! A lifeline to unite the culture.
Description: The first time I visited Memory and Kelvin and their siblings in their home was the first time I felt strongly that there was no hope for one of our children. I saw the Care Workers pour love out on them and that was when I realized that the love of the Care Workers is what brings hope. I have this picture up in my room and it reminds me to pray for them by name.
Description: After riding motorbikes through the jungle to a remote village, we came across children who had not yet been 'found' and brought under the care of the Community Based Organisation. Dayo was one of the most broken and traumatised children I have ever met, having been abandoned by his mother as a new-born. He now attends school with his older brother, eats at the Care Point each day and receives regular and loving home visits from the Elekuru Care Workers.
Your short description: We visited Madris in his home. When asked where he slept we were directed to a kitchen hut no more than 1.5m in diameter – half filled with cooking equipment, the other half he would share to sleep in with his older brother. It was heart wrenching to see the squalid and unsafe conditions he slept in every night. The only reason I could walk away from this situation was knowing Madris has a Care Worker Henry, who visits Mandris almost every day, and cares for Mandris as if he was his own son. For me, this photo captures the beautiful relationship between Care Worker and child that is so foundational to who we are as Hands at Work.
passing moment a smile broke across her face.
This photo was sent to us by Fortunate and is taken at Siyathathuka Community Based Organisation in Clau Clau, South Africa.
It is of 5 families who take home fresh spinach from the garden Fortunate made.
The Care Workers and children there now have a large garden and I believe more children are taking home fresh vegetables which will help their health.
The reason that it means so much is that while our team were there we were able to replace the pump in the borehole so that they have water to enable their garden to grow.
It has just shown me the difference that water can make to a community in so many ways.
Our God is so good and provides - it was great to see them recognize this and to be so thankful to God for it.
This picture brings me hope. Tanazio is teaching children in the morning at the Care Point in Maonde community, Malawi. It brings hope for the future, hope for these children, and to me represents how the Care Workers serve vulnerable children across our communities.
I stayed with Senty and her family just weeks after coming to Africa for the first time. Her mother is 19 and was taking care of their household because her own parents have passed away. Their family is one of the poorest and most vulnerable in South Africa. But meeting Senty made me realise that a child in the most dire situation in Africa is not that different from a child in Canada. Their souls are the same. Senty is creative, bright, spunky, naughty, loud, beautiful, and has the biggest imagination. When I asked her what she wants to be when she grows up, she said a frog. I feel every bit of her spirit when I see this photo and it's second best to being with her in person.
In 2009, 6 young children were devastated by the loss of their parents. The eldest girl, Busie, 15, took responsibility for their mentally challenged and mute brother, Robert, and an uncle offered to take in the four youngest siblings: Segney, Gertrude, Ronald, and Karimo. It wasn't long before the children realized they were not going to experience the care and provision they had anticipated from their uncle. Their uncle began stealing the small government orphan grant being given to the four orphaned children. On many nights, the children went to bed without food and often went to school without adequate clothes. One by one, the children fled from their uncle to their old home.
In 2011, Busie became pregnant and gave birth to a baby girl. With no one to help Busie raise her daughter and siblings, and with repeated years of failing at school, Busie dropped out in Grade 8. Motivation to continue attending dwindled and the hope for a brighter future became bleak. Housework and providing meals for the family became overwhelming. The growing instability in this family's life started to affect the other children's school work and their teachers became concerned. Aware that the family was in need of support, the teachers asked Care Workers at Pfunani Community Based Organisation to help.
Ester, a Pfunani Care Worker began to visit the family and look for ways to support them. She helped the children to apply for a social grant which they are now receiving. Each morning, Care Workers visit the family home on their way to the Care Point to ensure porridge is cooked for Robert. During other home visits, Ester helps to ensure the house is clean, laundry is washed, and meals are cooked. Although Busie still struggles with feelings of depression, the family are discovering a new reality of hope. Not only are they fed physically, with a nutritious meal each day at the Care Point, but also spiritually and emotionally. They enjoy interacting with other children at the Care Point and attend weekly lessons led by their older peers, where issues such as self-esteem, healthy relationships, and sexual education are discussed.
Ester desires to continue helping Busie and her family to experience brighter days, to understand that they are loved and embraced as family.
The McLaughlin family and friends desired to make their partnership with Pfunani Community Based Organisation personal. They wanted it to go beyond just the sending of funds. This group are getting to know the Care Workers and children by name, and they look for creative and meaningful ways to impact their lives and the community. In 2013, they formed a team and travelled to South Africa to spend time with the people they had grown to love. During their time in the community, they worked to make the Pfunani Care Point a safe, secure and fun place for the children and Care Workers to meet.
Children like Busie and her siblings, who have battled with so much loss and rejection, now find a place of acceptance and value. The McLaughlin family and friends work closely with Hands at Work to make a positive impact in the lives of these vulnerable children. And through it, they have discovered a new reality of hope for the children and Care Workers they know by name.
Have you considered sending a team to visit Hands at Work, or joining other individuals who desire to bring hope to the most vulnerable? Find out how you could get involved with Hands at Work by sending a group of passionate people to serve on a short-term team. No skills are required, just a commitment to serve and a desire to care.
Anna "Oumie" Snyman is a true blessing from God to the Hands at Work Family. She is the mother of our Founder and CEO, George Snyman, and now lives at the Hands at Work HUB in South Africa where her gift of intercession calls God into the lives of all volunteers, Care Workers, and vulnerable children. Though Oumie prays for all our countries from South Africa, the entire Hands family rejoiced when she recently had the opportunity to travel to Zambia. We knew it would be special for the Hands Family there to be blessed with her presence, and as she describes her journey, we see God used her as a great encouragement.
"I couldn't believe I was going. I mentioned it and three days later, I was going!" Oumie said God gave her one of the greatest desires of her heart when he made a way for her to go to Zambia recently. Psalm 37 had always been her favourite and she felt so blessed to see the Lord's word in action.
Having never been to Zambia before, the whole journey was an unexpected adventure. Describing the ferry she took to cross the Zambezi River she said, "As far as I'm concerned, a 'ferry' is a small boat. This ferry had trucks right on it! I seriously considered hitchhiking". She saw beautiful sunsets and was blessed with her first visit to Victoria Falls where she was amazed by the size and sounds of the incredible waterfall.
In Zambia, James Tembo, Zambia RST Coordinator, walked with Oumie in the community of Zimba. She was touched by a group of local people who were building a house all on their own. She was also blessed by two people she knew only through her son George, and on this trip got to meet: Hilda and Charity.
Ten years ago, as George walked across Africa, he came across a lady who took him in to her church where the congregation prayed for him and prayed that he would go out and tell others about Africa. This lady's name was Hilda. George never saw her again until a few years ago when he was in Zambia for the Hands at Work celebration. George was in Zimba, walking through the village, when he saw Hilda! He brought her to celebrations and she has since been a Care Worker at Zimba CBO.
One year ago, George came home from Zambia with a photo of a three year old girl named Charity. She looked like she was only one years old and George knew she was close to death. She was neglected by her family and her Gogo could not care for her properly. As a family, the Snyman's began giving extra to her; Oumie sent clothes and sweets with others travelling to Zambia, just for Charity. And Oumie prayed for Charity.
On this trip, Oumie met Hilda when she went on Home Visits with James. When they arrived at the Community School, Oumie met Charity. "She was healthier, she was laughing. Now she looks four years old!" Oumie said, "Hilda is a lady of God who has adopted her and cares for her so much." Charity immediately connected with Oumie and made sure everyone knew Oumie was her friend. When Charity's brother came to meet Oumie, Charity became jealous and sent him away! Oumie was so thankful that Charity looked so well, that their family had been blessed to be involved in this young girl's life. Oumie saw the transformation Zimba CBO is making in the lives of vulnerable children. She saw how wonderful the Community School is and how the children have a safe place to go each day and be fed and be filled with joy.
Nora is a volunteer care worker at the Mandlesive Community-Based Organisation (CBO) in South Africa. As a care worker, she joins several other men and women who share her heart of servanthood to bring hope to the most vulnerable children in her community. The care workers visit these children regularly, offering help with homework, spiritual guidance, and a listening ear. They walk them through heartaches and encourage them to follow their Father and the plans He has for them. Evidently, their stories are every bit as compelling as those of the children whom they serve.
"After my boyfriend left me alone to care for our daughter, I started selling home grown vegetables to earn a living. It was tiring work, and often left me stressed and tired at the end of the day. At the time both my sister and my mother were very sick, and I found myself caring for them and my sister's children in addition to my daily jobs.
My only hope was these women who would come and visit my sister each day. They taught me how to bathe her and care for her. Once my sister died and my little family gained four more, children, I decided that it was too much to bear and I needed some way to cope with my life's situation. Then my mother passed away. This is when I asked to join these faithful women who had been devoting their days to caring for my sister and her family.
Now that I am a careworker at Mandlesive Community-Based Organisation, I couldn't ask for a different life. I care for nine orphans by assisting them with their daily activities such as washing, cooking, helping them with their homework, just as the other careworkers cared for my family. Giving to the community from the bottom of my heart is the reason that I get up every day; the reason that I can cope with losing my sister and my mother. There are often times where I must give up some of my family's support in order to bring necessities to these children, and sometimes it is difficult for me to explain this to my family. Sometimes people laugh at me and tell me that I am stupid to be giving up my life to care for other people. While this hurts me, the pain of seeing a hungry child hurts more.
The Lord has overwhelmed me with his blessings. He has kept me and my family safe – there are many times where I have worked with very contagiously sick patients, and He has spared me from illness. My daughters are happy and healthy, I have sweet potatoes in the garden and mangoes on my trees, and my family has food on the table each night. I am able to love these orphans that I care for as my own children because I recognize that it's not my love to give. Our Father has so richly blessed us with His love, and I know that the love that I show these orphans does not come from me, but Him.
Nora was recently trained by Hands at Work, through the Walking with Wounded Children Program. The training, developed by a team of counsellors and psychologists, equips those who care for children with tools to lead them on a path of healing from any emotional wounds or losses they may have experienced. This training, combined with the love embedded in the hearts of women like Nora, are bringing God's hope to vulnerable children across Africa.
Loveness walks to visit the patients and children whom she serves. Most of their homes are deep in the Zambian bush.
It is Tuesday. The sun is particularly hot and the sand below her feet is dry. Loveness is accompanying a care worker on one of her daily home visits. They arrive at a home nestled in the bush, where a grandmother sits on a grass mat, and leans against the wall of her home. She has been sitting on this mat from the time the sun rose, and will stay there until she is ready to go to bed. She is the guardian of Agnes*, her seven-year-old granddaughter. Agnes' mother passed away due to HIV, leaving her behind with her memory, and her disease. Seven-year-old Agnes and her grandmother take care of each other, but there is no source of income, and their small home is not secure and is falling apart.
David Da Costa is a musician from Mozambique, living in Australia. Him and his wife, Carly, give time volunteering for Hands at Work in Australia. Inspired by stories of desperate African communities, they wrote this song and we are giving it to you now as a free download.
Diamonds in the Dust from Hands at Work in Africa on Vimeo.
Buried in the backrooms of poor communities, these youth are truly our diamonds in the dust, and worth a lifetime of searching for and discovering them.
Christa Roby, a massage therapist in British Columbia, Canada, volunteered with Hands at Work for six months in South Africa in 2010. Two years later, she feels an undeniable pull to return. Read her reflections as she prepares to pack up her life in Canada and follow her heart, and God's calling, to Africa.
"For me, it's harder to be away from Africa than it is here... It's where my heart is. After being there so much and having that time with the people there, and seeing someone who has so little, but gives so much, it just becomes something you want to be a part of, something you want to share in...It's raw, it's innocent, and it's a deeper sense of fulfillment."
Read the rest Christa's reflections on coming back to Africa in the Chilliwack Progress.
"I soon realized that making the decision and actually doing the follow-through are two very distinct acts. But no matter how big the effort to follow-through would be, I knew in my heart I would walk it out."
To raise money for her trip, Christa hosted a charity gala in her hometown. Read about it on the Hands at Work Canada Page.


text:
Panel: Marginalized Groups at Higher Gun Violence Risk
November 22, 2019 by Margie Cullen Leave a Comment
Policymakers and gun reform activists emphasized the disproportionate effect of gun violence on marginalized communities at a Nov. 19 event.
Sen. Chris Murphy (D-Conn.) and Washington, D.C. Mayor Muriel Bowser (D) gave opening remarks at the event, "Only in America: Examining the Everyday Toll of Gun Violence" in the Healey Family Student Center Social Room. The event was sponsored by the Georgetown University chapter of March For Our Lives, a national student-led anti-gun violence organization, the Georgetown University College Democrats, the American Civil Liberties Union, the Georgetown Institute for Politics and Public Service and the Georgetown University Lecture Fund.
Four panelists examined why gun violence unduly affects certain racial groups more than others and proposed solutions to address gun violence in the United States. The panelists included Joseph Sakran, director of emergency general surgery at Johns Hopkins Hospital; David Chipman, a former agent at the Bureau of Alcohol, Tobacco, Firearms and Explosives; and Helisa Cruz, high school outreach director for MFOL D.C.
Rep. Robin Kelly (D-Ill.) was scheduled to join the panel but was unable to attend and was replaced by Igor Volsky, the director of Guns Down America, a gun reform organization known for its strong opposition to the National Rifle Association.
ALEX BAKER FOR THE HOYA | In an event hosted by the Georgetown Chapter of March for Our Lives, panelists discussed ways gun violence disproportionality affects marginalized communities.
Murphy recounted a personal experience about a school he visited in Sandtown, Baltimore — a primarily black community — that went into "code green" during his visit, meaning an active shooter was several blocks away. The experience helped Murphy understand the horrific psychological effects shootings have on children, he said.
"Every single kid at that school is faced with this reality that they might come to school that day and when they get home their parents won't be there either," Murphy said. "They fear for their lives when they walk to school, when they walk home, when they run out to the corner grocery on the weekend for their parents."
Baltimore has one of the highest rates of gun violence in the country, with over 500 people shot in nonfatal incidents and more than 150 killed as of July 2019, according to the Baltimore Sun.
Gun violence takes a high emotional toll on people's lives, especially young people, who face the risk of dying young from gun violence in some communities, according to Cruz, a resident of northeast D.C. and a senior at BASIS D.C. Public Charter School.
"There are so many of my friends that have friends that should be writing their college essays with me, that should be experiencing any of these college processes but they're not because they're dead," Cruz said.
Gun violence disproportionately affects marginalized groups, despite often only receiving widespread media attention when it affects white children, she said.
"It seems like the media only cares when white kids die and I'm like, that's unfair, because I feel as though black and brown kids deserve to live," Cruz said. "Just because of the opportunities we aren't given in a system that suppresses, is it really that fair that we won't be able to live?"
There are nearly 33,000 gun deaths in the United States annually, and nearly one-third of these are homicides, based on averages from 2012 to 2014. Black Americans are victims of gun violence at significantly higher rates than other racial groups, with a rate of 16.7 homicides per 100,000 people, compared to 1.5 homicides per 100,000 white Americans, according to Five Thirty Eight.
Sakran agreed that gun reform only occurred after gun violence impacted predominantly white communities.
"Frankly, it wasn't until suburban white students started getting shot up that all of a sudden people started to care," Sakran said.
Despite the ongoing epidemic of gun violence, campaigns to address gun violence are gaining large-scale support, Murphy said.
"The good news is this country is waking up," Murphy said. "What we have become in a short six-year period of time is more powerful than the gun lobby. We have more money, we have more activists, we have more voters that care about our issues."
Just four years ago, politicians were not having the same in-depth conversations about guns that they are having today, according to Volsky.
"For a long time, politicians from both sides of the aisle, but certainly from the left, felt that talking about guns was a big liability," Volsky said. "But what's happened since is that, really, a growing realization that young people like you care about this issue and that you will vote based on this issue."
Educating the Georgetown community about the levels of gun violence in marginalized communities in D.C., as well as across the nation, is critical, according to James Benner (SFS '21), a member of the Georgetown chapter of MFOL and one of the organizers of the event.
"Unfortunately ,there are high rates of gun violence in other sections, particularly in communities across the river that I think goes unnoticed by the Georgetown students and the Georgetown community," Benner said. "The main purpose of this event was just to bring in some of those voices who have experiences and who live in those communities who are regularly affected by gun violence."
About Margie Cullen


text:
Furman Libraries Spring 2013 Newsletter
The Furman Libraries published their Spring 2013 (Issue No. 2) of their newsletter FULCRUM. (April 5, 2013)
Obama Administration Issues Directive to Expand Public Access to Federally Funded Research
The White House Office of Science and Technology Policy has issued a directive on Public Access to Articles and Data. This comes three and a half years after 60 Oberlin group Presidents signed a letter in support of FRPAA (Federal Research Public Access Act.) (February 21, 2013)
Public Access to Peer-Reviewed Scholarly Publications Based on Federally Funded Research
In response to the White House Office of Science and Technology Policy Request for Information on public access to peer-reviewed scholarly publications resulting from federally-funded research, the Oberlin Group submitted comments on behalf of the 80 members. With the threat of the Research Works Act (HR3699) possibly turning back the progress made by the NIH mandate, this is a critical time for libraries to respond and advocate for more access, not less. (February 1, 2012)
The Oberlin Group endorses the Berlin Declaration
The Oberlin Group: A Consortium of Liberal Arts College Libraries endorses the Berlin Declaration on Open Access to Knowledge in the Sciences and Humanities. (October 26, 2011)
Developing Copyright Policy for Liberal Arts Colleges
Developing Copyright Policy: A Guide for Liberal Arts Colleges by Kevin Smith is now available from the Resources Tab of the Oberlin Group website. (July 13, 2011)


text:
Richard Doyle Taylor
Posted about five months ago
Richard Doyle Taylor, 85, of South Coffeyville, Oklahoma passed away Thursday, February 7, 2019 at his home.
He was born on June 17, 1933 in Nowata County, Oklahoma to Lee Wesley and Leona Mae (Kivett) Taylor. Doyle grew up in and attended school in Nowata County graduating from Lenapah High School in Lenapah, Oklahoma. He also attended Coffeyville Community College and McFarland Trade School.
Doyle was a veteran of the Korean War serving in the U.S. Army from May 27, 1953 until receiving his honorable discharge on May 13, 1955.
On November 25, 1956 he married Katherine Louise Winkler at the Emmanuel Baptist Church in Coffeyville. Following their marriage they made their home in Coffeyville until moving to South Coffeyville in 1958, in 1963 they returned to Coffeyville, returning to South Coffeyville in 1981. Doyle was employed as a butcher at Butcher's Packing Co. later he became the manager of Butcher's Firestone after Butcher's closed he was welding manager at Jensen Mfg. and later welding foreman at Dixon, Ind until retiring in 1995. After his retirement Doyle stayed busy butchering for many local farmers, ranchers and game hunters.
He was a long time member of Holy Name Catholic Church, and a life time member of Veterans of Foreign Wars Post #1022. Doyle enjoyed hunting, fishing and he loved having fish fries, but his greatest joy was spending time with Kathy surrounded by their children, and their families, and close friends.
Left to honor Doyle's memory are his wife, Katherine "Kathy" Taylor of the home; three daughters, Sherry Taylor Perkins and husband, Mike of South Coffeyville, OK, Tammy Taylor Thompson and husband, Roger of South Coffeyville, OK, and Penny Taylor Beecher and husband, Bradley of Carl Junction, MO; grandchildren, Tara Witwer and husband, Mike of Dearing, KS, Heath Perkins and wife, Kiesha of South Coffeyville, OK, Melissa Thompson of Broken Arrow, OK, Jeremy Thompson of Phoenix, AZ, Austin Thompson of Laveen, AZ, Krystal August and husband, C.J. of Carl Junction, MO, and Madison Beecher of Springfield, MO; eight great-grandchildren; one brother, John Logan Taylor; and one sister, Betty Colleen Taylor Robison.
He was preceded in death by his parents, Lee Wesley Taylor and Leona Mae Taylor; two brothers, Donald Lee Taylor and Charles Kenneth Taylor; and two sisters, Katherine Taylor Bennett, and Wanda Darlene Taylor Johnson.
A Rosary Vigil Service will be at 7:30 p.m. Tuesday, February 12, 2019 at Holy Name Catholic Church in Coffeyville.
Mass of Christian Burial will be at 2:00 p.m. Wednesday, February 13th at Holy Name Catholic Church. Burial will be in Calvary Cemetery in Coffeyville with Military Honors conducted by V.F.W. Post #1022 and American Legion Post #20.
Friends may call on Tuesday from 9:00 a.m. to 5:00 p.m. at the David W. Barnes Funeral Home in Coffeyville.
The family suggests memorials in Doyle's memory to Holy Name Catholic Church; contributions may be left with the funeral home or mailed in care of David W. Barnes Funeral Home, 306 North Cline Road, Coffeyville, KS 67337.
To leave a message for the family please visit www.dwbfh.com.
David W. Barnes Funeral Home of Coffeyville is in charge of arrangements.


At Dumpster Blog, we strive to bring you the best service at the best price available. We have a wide selection of dumpster sizes in stock in Cave City, AR, with flexible & timley pickup and delivery. Give us a call today for all your dumpster rental and roll off needs.
Your roll-off dumpster in Cave City, AR is only a phone call away. Don't delay!
Check the dumpster corporations policy about what cannot be included to their dumpster(s). For instance, many dumpster companies will never permit real in their dumpster. Concrete floor can stick and result in the dumpster to weigh a lot more, take up bedroom and essentially make the dumpster significantly less useful mainly because it should be.
Hire a contractor to get the remodeling accomplished. He or she can substitute your microsoft windows, baseboards, drywall, carpeting, vanities, cupboards, old wooden flooring, etc. Some sort of dumpster will come in handy when putting all of the outdated items out.
Why are these facilities beneficial for an individual? Be it improving your home or maybe constructing a new one, you just have much to do in addition to disposing in which trash at the conclusion of the day. You may have to take charge of the interior, portray, dcor, getting somebody to cook in a social gathering. It really is a full time job. You can even opt for these services if you would like to conveniently get rid of the trash that your particular barbecue social gathering left behind.
Actually, with a through your nearby junk removal service, you can finally say great riddance to every previous heap connected with trash around your property and free up the indoor and outdoor area for a whole new set of hard drive and use possibilities. Almost all junk transporting services may handle nearly everything from product disposal to household furniture disposal, excluding hazardous squander, asbestos supplies, and health-related supplies. You may also have the dumpster delivered at your house and do the heavy lifting yourself to save the the final cost of all that junk removal.
At this point comes in this question the way to choose a suitable company having affordable charge. If you want to pick any of the corporation for this service and are puzzled by which one to go along with then web is the best manual. On internet you will discover many companies supplying such companies. You can assess quotes making your decision relaxing at home. World wide web can even allow you to pay for the skills online along with your credit card or any other options that the company could provide you with.
The particular 15 cubic property Cost of a Roll Off Dumpster in Cave City, AR you will want if you are remodeling and picking up all of the debris through your kitchen, an enormous garage, basement or attic clean-out such as if you are cleaning out your home from a loved one person, a large yard that will require massive cleanup, or a basement remodeling task.
For this reason, a lot of people choose to rent some sort of dumpster for their home rehabilitation or clean-up projects. The dumpster can be placed in a convenient location and will maintain tons of dust, keeping the item safe from community children or maybe curious insects. When your undertaking is complete, this Cost of a Roll Off Dumpster in Cave City, AR company may pick up this container instantly and dump the subject matter for you with an approved removal facility.
Essentially the company has been around for at least a few years to really build themselves. This can ensure that they may be unlikely to make some mistakes and their status would be more essential to them. They may have spent a long time building a reputation for themselves to simply rebrand if they obtain too many complaints.
Discover going to reuse the baseboards in your your kitchen when you are during remodeling, you can throw these individuals into the dumpster as well.
Ever check out the television display Clean Mop and wish which cleaning your house construction challenge could be simple? Renting a dumpster for a remodeling projects and for eliminating construction products is the solution. Removing dust is going to be bigger than anyone thought. Renting an individual dumpster is the perfect way to help haul aside those dumped materials off your property. Best of all the professionals are making the entire rental process incredibly hassle-free and they present low rates that permit cleanup being affordable and simple.
In your pursuit to keep your house neat and clean, usually consider the building Cost of a Roll Off Dumpster in Cave City as a reputable help. Your own home will surely search the best that it will even after a construction task because squanders are adequately disposed with the help of a Cost of a Roll Off Dumpster in Cave City The town of jacksonville.
Many people goes their entire lives without previously needing to get into Cost of a Roll Off Dumpster in Cave City. Others might do it each day. But for those who work in between, it could possibly seem like somewhat of a labyrinth as soon as deciding how to make it. Have you ever a huge occasion in the preparing and need a method to dispose of each of the trash. You could be planning a massive demolition and need a quick location to store dust without taking countless trips on the dump. Unpleasant, there are those who can help you acquire just what you'll need. Here are some ideas that might help you obtain started.
One thing is for confident we all help make trash. All of us put your trash within garbage totes and then we carry it off. But they can you just have excessive trash to help haul off easily. Some families only make more rubbish than others this means you will be a massive hassle to help haul that away at all times. If you have many trash and never want to carry it off consistently or whatsoever you could use spin off dumpster renting. You may have certainly not heard of a new roll off Cost of a Roll Off Dumpster in Cave City before however, you may have noticed one. When you visit the dumpster you generally stick your current trash inside a big dumpster rubbish bin. They are usually coated green at least around below.
Once you have chosen an appropriate receptacle based on your family needs the company you choose will provide it for a property. You have to decide concerning the best area for the receptacle. If the receptacle is needed at your residence, the best place is the driveway. Most of the receptacles feature wheels and this also makes it easy to move them.
By 2011, televisions, computers, notebook computers and computer monitors are banned from the trash in accordance with New Jersey's Electronic Spend Management Act (Act).
Qualified estate cleanout businesses have employees on staff who can help you determine which of your family member's possessions have got resale worth. If you're filling out a cleanout beneath emotional scenarios, it can be straightforward to assign worth to every little thing the deceased person cared about. An appraisal expert would bring a sense of viewpoint to the proceedings. However, in case you are doing a good estate cleanout in which you don't mean to resell anything at all and simply would like to take a handful of key things home and obtain rid of the remaining, you most likely don't need appraisal and searching assistance. Rent a new dumpster from a rubbish removal business and have the items alone.
Dumpster One on one is on the internet roll off container rental supplier based in Us renowned for it customer centric services throughout the nation. The user friendly designed site makes you encounter that the nav right from the start of the deal to finishing of the deal wasn't this effortless earlier. Your fleets of products of Dumpster direct consist of 10 yards to 45 yard dumpster providing any kind of prerequisite according to tailored needs of the customer.
Whenever building your home, you will need to look into what size of dumpster you actually need. Can the home be considered a smaller project thus just needing a medium sized dumpster? Your medium sized dumpster hold three plenty of debris or five pickup loads. You might need a large dumpster that will hold a number of tons of trash or 10 pickup truck a lot. Most likely you'll need a medium or large dumpster, not really a small dimensions dumpster that retains two plenty of debris.
Whether you're an individual home-owner or the scalp of a design company, the vital thing to take care of about the "to do" list ought to be a Cost of a Roll Off Dumpster in Cave City, AR. If you are a individual, then renting your dumpster yourself can save a lot of money in your home renovation project. First will come the demo, then the renovation. In the meantime, xbox to be a good place to keep all of the old materials which has been taken off a constructing.
Planning a home remodeling project for instance a bathroom, kitchen, or family area renovation as well as a cleaning-up or clearing-out remodelling can seem just like a huge difficult task without the proper cleanup instruments. Renting a dumpster will let you support the trash during the renovation course of action and carry it out conveniently in one easy treatment process. Here are some dumpster facts that will help you in selecting the very best dumpster for your project.
A specialty services that requires Cost of a Roll Off Dumpster in Cave City, AR is community cleaning programs along with charity kind projects. Most of the dumpster company work with the manager of such of an event and often times implement discounts for your sake of the community. The service this way that makes your professional garbage solution organizations stand out from the remainder and make these individuals the one halt company that you can go to with regards to dumpster needs.
You must ensure that you understand what you can and can't dump in your dumpster. Different Cost of a Roll Off Dumpster in Cave City, AR organizations have different regulations, but they also will at the least abide by the guidelines of your surrounding area. Of course, you are not allowed to eliminate all risky materials such as liquid fresh paint or gas or any other factor that have very strict guidelines regarding their convenience. In case, you city possess recycling regulations, you need to pay attention to them as well.
There is a need for every single sector of the society o take precautionary action contrary to the pollution that is generated near your vicinity, specially in designed nations like US. It is unavoidable for the nation to continue industrialization in spite of generating air pollution. It is unattainable to stop the generation of the spend completely. In order to to mitigate the effect of the air pollution on the atmosphere is to reuse the generated waste inside Eco-friendly manner. The full responsibility of reducing the air pollution does not rest solely while using industries; action should be used right from your home owners. Your waste is generated in a variety of projects such as house remodelling, construction project, green backyard waste along with industrial spend. Proper action should be used at every market to recycle your generated spend to mitigate the consequences of air pollution. Dumpster rental from a specialist Cost of a Roll Off Dumpster in Cave City, AR provider is the foremost solution to reuse the spend in an Eco-friendly fashion. These specialist Cost of a Roll Off Dumpster in Cave City, AR companies on the market provide Cost of a Roll Off Dumpster in Cave City, AR for just a period per you and get those waste dumped into the dumpster to reuse it inside environmental friendly manner.