Chuletas y apuntes de Inglés de Otros cursos

BICIMAD y Procesamiento de Datos

BICIMAD: otra línea

Usuarios tipo: df.groupBy("user_type").count().show()

Seleccionar usuarios tipo: sel_type = int(input('Introduce..: '))
df1 = df.filter(df["user_type"] == sel_type)
df1.count() # o sel_type = 2, df1 = df.filter(df.user_type == sele_type)

Uso diario: df_trips = df1.groupBy('user_day_code').count().show()
# df_anual = df.filter(col("user_type") == 1)
viajes_usu = df_anual.groupBy("user_day_code").count()
viajes_usu.filter(col("count") == 1).count()

Estación destino: df.groupBy('idunplug_station').count().show()

Estación destino con distinción: df.groupBy('idunplug_station').agg(count_distinct('idplug_station')).show()

Adyacencia y frecuencia:
edges = df.groupBy("idunplug_station", "idplug_station").

Diario de viaje: vacaciones en Galicia

Today I have been vacationing in Galicia. At 6 in the morning I caught the car with my family. About 11 a.m. we stopped at a roadside bar for breakfast and, after a long journey, we arrived at our hotel in Pontevedra at about 2 p.m.

El hotel y la ciudad

The hotel is small but very nice and is next to the beach. We have visited the city and then we went for a walk along the beach. We tried a bath, but the water was very cold.

Planes para mañana

Tomorrow we will go to Santiago and Finisterre. We hope they are as beautiful as my friends told me. But before that, we will dine at the harbor, which is very nice at night.

Tomorrow I will tell you more.

Gramática inglesa

Voz pasiva (Passive Voice)

• Present simple: Sells

Evaluación con adjetivos y sustantivos: Enough

• Adjective + enough: cantidad de.

• Enough + adjective: suficiente.

Subject: Después / Si o sí: Antes.

Es / No es. No son / Son. ---

Comparaciones con adjetivos y sustantivos

• As + adjective + as (< to be): tan… como.
• Just + as + adjective + as: casi tan… como.

• As many + countable noun + as: tantos… como.
• As much + uncountable noun + as: tanto… como.

Wishes

Deseos y anhelos.

Subject + wish(es) + Subject + were / past simple.

Past Simple

Acción pasada que terminó.

Subject + V2 (pasado)
Subject + did not (didn't) + V1
Did + subject + V1 + ?

Present Perfect

Acción pasada que continúa hasta el presente.

Subject + have / has (haven't / hasn't) + V3 (participio)
Have / Has + subject + V3 + ?

Secuencia de adverbios

First:...

Ejemplos de Correspondencia en Inglés

A continuación se presenta una recopilación de diversos modelos de textos y correos electrónicos redactados tanto en un tono informal como formal, ideales para practicar la redacción y la comprensión escrita en diferentes contextos cotidianos y profesionales.

Modelos de Mensajes Informales

Carta Informal: Experiencia en el Campamento de Verano

INFORMAL. Hi Vero,

How are you? Thanks for your email. It's great to hear from you again.

Well, I wanted to tell you that I've just arrived from my summer camp and it was awesome. I spent 1 month in Cantabria and life there is very different from life in Sevilla. I really enjoyed it. I met new people there. The weather was not the best, but anyway I had a lot of fun....

Ejercicio 1

(SELECT clt_id AS idcliente, 'Oro' AS Nivel, CONCAT(clt_nome, ',', clt_apelidos) AS Nome FROM clientes
JOIN vendas ON clt_id = ven_cliente
JOIN detalle_vendas ON ven_id = dev_venda
WHERE (YEAR(ven_data) = 2012)
GROUP BY clt_id
HAVING (SUM(dev_cantidade * (dev_prezo_unitario * (1 - IFNULL(dev_desconto / 100, 0)))) > 5000 AND SUM(dev_cantidade * (dev_prezo_unitario * (1 - IFNULL(dev_desconto, 0)))) < 1500))

UNION

(SELECT clt_id AS idcliente, 'Plata' AS Nivel, CONCAT(clt_nome, ',', clt_apelidos) AS Nome FROM clientes
JOIN vendas ON clt_id = ven_cliente
JOIN detalle_vendas ON ven_id = dev_venda
WHERE YEAR(ven_data) = 2012
GROUP BY clt_id
HAVING (SUM(dev_cantidade * (dev_prezo_unitario * (1 - IFNULL(dev_desconto / 100, 0)))) >...

Lista de Verbos Irregulares en Inglés

A continuación encontrarás una lista de verbos irregulares en inglés con sus formas en pasado simple, participio pasado y su traducción al español.

Verbos irregulares A–B

arise – arose – arisen – surgir, levantarse

bear – bore – borne/born – cargar

bend – bent – bent – doblar, encorvar

bet – bet – bet – apostar

bind – bound – bound – atar

bid – bid/bade – bid/bidden – ordenar

bleed – bled – bled – sangrar

breed – bred – bred – criar

bring – brought – brought – traer

broadcast – broadcast – broadcast – difundir

burst – burst – burst – reventar

Verbos irregulares C–F

cast – cast – cast – echar

creep – crept – crept – moverse furtivamente

deal...

How a Dentist is Trained in My Country

Introduction to a Dental Career

Dentistry is the occupation concerned with the prevention and treatment of supporting tissues, oral disease, and particularly diseases of the teeth. In addition to universal practice, dentistry includes many areas of expertise and subspecialties, such as:

• Oral surgery
• Prosthodontics
• Pedodontics
• Public health dentistry
• General dentistry
• Paediatric dentistry
• Oral pathology

It is the job of a dentist to be fully aware of different types of problems and be able to recognise those problems.

Dentistry in Spain

In my country, all dentists go through at least five years of schooling after high school and earn a degree in general dentistry; this consists of five years of undergraduate work and...

Society and Modern Challenges

Internet Bullying

The government announced today that it will put millions of dollars into fighting internet bullying, an activity which affects the lives of teenagers across the world. New education programs in schools and colleges will show young people how to protect themselves while they are online.

Alternative Energy

It is obvious to all but the most skeptical that the need to develop alternatives to fossil fuels is increasingly urgent. Whether the solution turns out to be solar power, wind farms, or something else will depend partly on local conditions, but ultimately on economics.

Social Media and Privacy

The meaning of fame has changed considerably in modern times. Celebrities are constantly under the spotlight;...

Es 1775. Hay problemas en el campo francés. Al parecer, la gente de allí no quiere morir de hambre ni ser asfixiada por los impuestos. ¿Quién lo hubiera imaginado, eh?

El regreso del doctor Manette

Al comenzar nuestra novela, un caballero británico con aspecto de hombre de negocios se abre paso hasta el corazón de París. Tiene una misión muy inquietante. De hecho, es casi suficiente para hacer llorar a cualquier hombre de negocios. Verás, dieciocho años antes, un médico francés fue encarcelado sin previo aviso (ni juicio alguno). Ha estado encerrado en la peor de todas las prisiones, la Bastilla. Después de casi dos décadas, fue liberado, nuevamente sin explicación alguna, y actualmente se hospeda con un antiguo sirviente suyo,...

OPINION ESSAY: The Impact of Social Media on Young People

Nowadays, social media is very popular among young people. Teenagers use apps like Instagram, TikTok and YouTube every day. In my opinion, social media has both positive and negative effects on young people.

Positive Effects

Firstly, social media has some good points. It is a good way to keep in touch with friends and family. We can also learn new things and find information very quickly. For example, we can watch educational videos or learn about other countries.

Negative Effects

However, social media also has some negative effects. Young people can spend too much time on their phones instead of studying or talking to their families. Also, some teenagers compare themselves with people on...