Mexico City Complaint Records (Through March 2023)

Dataset with 20+ columns about complaints in Mexico City. Including categories, dates, types of complaints and so on.

Perfect for clean data exercise since it has tons of dirty data.

This data is from the Attorney General's Office of Mexico City.

Tips

If you want to make a cleaning process, there are several techniques that are quite perfect for this dataset:

1. Categories-based imputation
2. KNN imputation
3. Divide you dataset in two. For instance, by 'TipoPersona' feature

Considerations

Some columns are not good for interpretation. For example, the 'Edad' column could be from the person who commited the crime or from the person who complaint about the crime. Explore the data and think about the best context for each column.

However, I can suggest some popular Netflix movies and TV shows that were well-received up to that point. Keep in mind that the availability of content on Netflix may vary based on your region, and new releases may have come out since my last update. Here are some recommendations:

Movies: The Irishman (2019): A crime drama directed by Martin Scorsese, featuring an ensemble cast led by Robert De Niro.

**Roma (2018): **A visually stunning drama directed by Alfonso Cuarón, exploring the life of a domestic worker in Mexico City.

**Bird Box (2018): **A suspenseful thriller starring Sandra Bullock, where characters must navigate a post-apocalyptic world while blindfolded.

**Extraction (2020): **An action-packed film with Chris Hemsworth as a black-market mercenary tasked with rescuing a crime lord's kidnapped son.

The Trial of the Chicago 7 (2020): A legal drama based on true events, depicting the trial of seven activists during the Vietnam War protests.

The Devil All the Time (2020): A dark and gripping psychological thriller with an ensemble cast, including Tom Holland and Robert Pattinson.

**Enola Holmes (2020): **A mystery-adventure film following the teenage sister of Sherlock Holmes, played by Millie Bobby Brown.

**The Old Guard (2020): **A sci-fi action film featuring Charlize Theron as the leader of a group of immortal mercenaries.

Mank (2020): A biographical drama directed by David Fincher, exploring the life of screenwriter Herman J. Mankiewicz during the making of "Citizen Kane."

**Da 5 Bloods (2020): **A war drama directed by Spike Lee, following a group of African American Vietnam War veterans who return to Vietnam.

TV Shows: **Stranger Things: **A sci-fi/horror series set in the '80s, blending supernatural elements with a group of kids encountering mysterious occurrences.

The Crown: A historical drama chronicling the reign of Queen Elizabeth II and the events that shaped the second half of the 20th century.

Narcos: A crime drama based on the rise and fall of notorious drug cartels in Colombia, with a focus on Pablo Escobar.

Money Heist (La Casa de Papel): A Spanish heist crime drama series where a group of criminals executes intricate plans to rob the Royal Mint of Spain.

**Ozark: **A tense thriller about a financial planner who relocates his family to the Ozarks to launder money for a Mexican drug cartel.

**The Witcher: **A fantasy series based on the book series, following Geralt of Rivia as he navigates a world filled with magic, monsters, and political intrigue.

**Dark: **A mind-bending German sci-fi thriller that involves time travel and multiple interconnected families across different timelines.

Mindhunter: A crime thriller series following FBI agents as they study and interview serial killers to understand criminal psychology.

Black Mirror: An anthology series that explores the dark and often dystopian aspects of modern society and technology.

The Umbrella Academy: A superhero series centered around a dysfunctional family of adopted siblings with extraordinary abilities.

PROGRAM: def display_netflix_content(): netflix_content = { "Movies": { 2019: ["The Irishman"], 2018: ["Roma", "Bird Box"], 2020: ["Extraction", "The Trial of the Chicago 7", "The Devil All the Time", "Enola Holmes", "The Old Guard", "Mank", "Da 5 Bloods"] }, "TV Shows": { "Drama": ["The Crown", "Ozark"], "Sci-Fi/Fantasy": ["Stranger Things", "The Witcher", "Dark", "The Umbrella Academy"], "Crime": ["Narcos", "Money Heist (La Casa de Papel)", "Mindhunter"], "Anthology": ["Black Mirror"] } }

print("### Netflix Content Explorer ###")

while True:
  print("

Categories:") print("1. Movies") print("2. TV Shows") print("3. Exit")

  choice = input("Select a category (1-3): ")

  if choice == "1":
    print("

Netflix Movies ###")

    for year, movies in netflix_content["Movies"].items():
      print(f"

{year}:") for movie in movies: print(f"- {movie}")

  elif choice == "2":
    print("

Netflix TV Shows ###")

    for genre, shows in netflix_content["TV Shows"].items():
      print(f"

{genre}:") for show in shows: print(f"- {show}")

  elif choice == "3":
    print("Exiting. Goodbye!")
    break

  else:
    print("Invalid choice. Please enter a valid option.")

if name == "_main_": display_netflix_content()

To find the latest and most accurate information on Netflix content, including new releases and trending shows or movies, it's recommended to check the Netflix platform directly or visit their offi...

This study analyzes whether femicide in Mexico has increased more severely than other life and bodily integrity crimes (e.g., homicide, culpable homicide, injuries, malicious injuries, abortion, and other crimes that threaten life). To achieve this, the Executive Secretariat of the National Public Security System database was cleaned and the number of femicides per 100,000 inhabitants was calculated, for the period from January 2016 to March 2022 in all states of Mexico. Through descriptive statistics, non-parametric analysis of means, and hypothesis tests, we demonstrate that the states with the highest number of femicides are the Estado de Mexico (State of Mexico), Ciudad de Mexico (Mexico City), and Veracruz; moreover, the number of femicides exhibits a growing trend while the total number of life and bodily integrity crimes does not. Finally, we forecast the number of femicides for the next five months. To our knowledge, there is no other article that analyzes the growth trend of femicide compared to other crimes. Visualizing and understanding that femicide is on the rise compared with other types of crimes can help the government and legislators generate policies that are consistent with the magnitude of the problem.

This study analyzes whether femicide in Mexico has increased more severely than other life and bodily integrity crimes (e.g., homicide, culpable homicide, injuries, malicious injuries, abortion, and other crimes that threaten life). To achieve this, the Executive Secretariat of the National Public Security System database was cleaned and the number of femicides per 100,000 inhabitants was calculated, for the period from January 2016 to March 2022 in all states of Mexico. Through descriptive statistics, non-parametric analysis of means, and hypothesis tests, we demonstrate that the states with the highest number of femicides are the Estado de Mexico (State of Mexico), Ciudad de Mexico (Mexico City), and Veracruz; moreover, the number of femicides exhibits a growing trend while the total number of life and bodily integrity crimes does not. Finally, we forecast the number of femicides for the next five months. To our knowledge, there is no other article that analyzes the growth trend of femicide compared to other crimes. Visualizing and understanding that femicide is on the rise compared with other types of crimes can help the government and legislators generate policies that are consistent with the magnitude of the problem.