The Show with Xander

Places and adventures we enjoyed

Escalada de roca indoor en familia y con amistades

Rock, wall, indoor, mountain, climbing

Bienvenidos al episodio"Comunidad en Acción", donde exploramos cómo puedes contribuir de forma gratuita a tu comunidad y mantenerla segura. Soy tu anfitrión, y hoy nos adentraremos en cómo hacer la diferencia en Brisbane reportando fallas al consejo municipal. ¡Comencemos!

Una manera de contribuir a la comunidad es estar atento y reportar objetos faltantes o peligrosos en nuestros parques. Podrías encontrarte con equipos de juegos rotos, bancos dañados o incluso condiciones peligrosas. Cuando te encuentres con estas situaciones, toma nota de la ubicación exacta y cualquier detalle relevante. Luego, comunícate con el consejo municipal a través de sus canales de reporte, que generalmente se encuentran en su sitio web oficial o llamando a su línea directa designada.

Otro aspecto importante es estar al tanto de equipos en mal funcionamiento en espacios públicos, como las parrillas para barbacoa. Estos servicios son disfrutados por muchos, pero si no funcionan correctamente, pueden representar riesgos. Si notas una parrilla que no está funcionando correctamente, como fugas de gas, perillas rotas u otros problemas de seguridad, no dudes en reportarlo. Notifica al consejo municipal, proporcionándoles la ubicación específica y una descripción del problema. Tu reporte oportuno ayudará a que el problema se resuelva rápidamente, permitiendo que todos sigan disfrutando de estas instalaciones públicas.

Ahora, hablemos de un problema que a menudo pasa desapercibido: los baños públicos con fugas en los parques. No solo desperdician agua, sino que también crean condiciones insalubres. Si ves un baño con fugas en un parque público, es crucial informar al consejo municipal. Indícales el nombre del parque, la ubicación exacta del baño y describe el problema en cuestión. Al reportar este problema, estás contribuyendo activamente a mantener espacios públicos limpios y seguros para todos en la comunidad.

Recuerda, reportar fallas al consejo municipal es una manera poderosa de tener un impacto positivo en nuestra comunidad. Cuando encuentres objetos faltantes o peligrosos en los parques, parrillas para barbacoa en mal estado o baños con fugas, no dudes en notificar a las autoridades correspondientes. Al hacerlo, participas activamente en el mantenimiento y la seguridad de nuestros espacios públicos.

Esto nos lleva al final de este episodio de "Comunidad en Acción". Gracias por acompañarme hoy. Recuerda que pequeñas acciones pueden tener un gran impacto. Si todos contribuimos a nuestra comunidad, podemos hacer de Brisbane un lugar aún mejor para vivir. Mantente atento a más episodios donde exploraremos diversas formas de marcar la diferencia. ¡Hasta entonces, cuídate y sigue contribuyendo!

Welcome to the Community Matters, where we explore ways to contribute to our community for free and keep it safe. I'm your host, and today we're diving into how you can make a difference in Brisbane by reporting faults to the city council. So, let's get started!

One way to contribute to the community is by being observant and reporting missing or dangerous items in our parks. You might come across broken playground equipment, damaged benches, or even hazardous conditions. When you encounter such situations, take note of the exact location and any relevant details. Then, reach out to the city council through their dedicated reporting channels, which can often be found on their official website or by calling their designated hotline.

Another aspect to keep an eye on is malfunctioning equipment in public spaces, like BBQs. These amenities are enjoyed by many, but if they're not working properly, they can pose risks. If you notice a BBQ that is malfunctioning, such as gas leaks, broken knobs, or other safety concerns, don't hesitate to report it. Notify the city council, providing them with the specific location and a description of the problem. Your timely report can help ensure the issue gets resolved promptly, allowing everyone to continue enjoying these public facilities.

Now, let's talk about an often overlooked problem—leaking toilets in public parks. Not only can a leaking toilet waste water, but it can also create unhygienic conditions. If you spot a leaking toilet in a public park, it's crucial to bring it to the attention of the city council. Inform them about the park's name, the toilet's exact location, and describe the issue at hand. By reporting this problem, you're actively contributing to maintaining clean and safe public spaces for everyone in the community.

Remember, reporting faults to the city council is a powerful way to make a positive impact on our community. When you encounter missing or dangerous items in parks, malfunctioning BBQs, or leaking toilets, don't hesitate to notify the appropriate authorities. By doing so, you're actively participating in the upkeep and safety of our public spaces.

That brings us to the end of this episode of the Community Matters. Thank you for joining me today. Remember, small actions can have a big impact. If we all contribute to our community, we can make Brisbane an even better place to live. Until then, take care and keep contributing!

Historia de Qantas y lo que me ha pasado hasta el momento

Thank you all for sharing, listening, watching.

Instead of: 1. copy

2. control f to search

3. paste

4. copy/paste again

You can use the data that you are looking for and search it all at once, then produce a file, all ready for you using Python.

https://youtu.be/4LYw8QsYRt8

https://github.com/XanderGr/EXCEL/blob/main/idmatching

https://youtu.be/YdO_6U39SyA

Remember if you like it a free thumbs up via Spotify 5 star is greatly appreciated

https://github.com/XanderGr/EXCEL/blob/main/Python_matching

# Define the search criteria for the column use the placeholder

# Read the excel file into a pandas DataFrame

# Filter the DataFrame for rows where the placeholder column matches one of the search criteria

# Check if there are any matching rows

# If there are no matching rows, create a text file to indicate there are no matches

# If there are matching rows, write the filtered DataFrame to a new excel file

https://youtu.be/-eqyjTX--kQ

Leave a thumbs up

https://github.com/XanderGr/EXCEL

Leave a 5 star

Share with mates and your family

First, let's understand what the code does. This script helps you filter through a large Excel file and save only the data that meets certain criteria into a new Excel file. The original Excel file is converted into a CSV file and then filtered based on a specified column to search for certain criteria. The sensitive information column is also filtered to remove empty cells, and then saved as a new Excel file with the current date.

To use this script, you'll need to replace the following variables:

* COLUMNTOFILTER: Replace this with the name of the column that you want to filter on.

* Error 1, Error 2, Error 3: Replace these with the criteria that you want to filter for.

* Sensitive Column: Replace this with the name of the column that contains sensitive information.

* COLUMNTOSEARCH: Replace this with the name of the column that you want to search for.

* SELECTED_CRITERIA: Replace this with the specific criteria that you want to search for.

Make sure you save your Excel file in the same directory as the script and update the file_name variable to match your file name.

Thumbs up via YouTube

https://youtu.be/Zzf6DxN0k0c

Remember to follow, share, leave me a great 5 stars via Spotify

Use the code via

https://github.com/XanderGr/EXCEL

Welcome to this tutorial on filtering Excel files using Python!

Have you ever found yourself sifting through a massive Excel file looking for specific rows? Maybe you needed to ticket certain orders for further action, but the thought of manually searching through the file filled you with dread. Well, fear not! In this tutorial, I'll show you how to use Python to filter an Excel file for specific order IDs and create a new file containing only the matching rows.

First, let's take a look at the code. We start by defining the search criteria - in this case, it's a list of order IDs that we want to filter for. To make this code more secure and protect sensitive information, we've replaced the actual order IDs with placeholders.

Next, we read in the Excel file using pandas, a popular Python library for data manipulation. Pandas allows us to easily filter and manipulate data in a tabular format, making it the perfect tool for working with Excel files.

Once we've loaded the data into a pandas DataFrame, we use the isin() method to filter the DataFrame for rows where the order_id column matches one of the search criteria.

If there are matching rows, we write the filtered DataFrame to a new Excel file. If there are no matching rows, we create a text file to indicate that no business needs to be ticketed.

And that's it! With just a few lines of Python code, we've filtered an Excel file for specific order IDs and created a new file containing only the matching rows.

But what if you want to use this code with different search criteria or file paths? No problem! This code is easily customizable - just update the search_criteria and file path variables to match your specific needs.

So there you have it - a quick and easy way to filter Excel files using Python. I hope you found this tutorial useful and informative. Thanks for watching, listening and happy coding!