Skip to content

Instantly share code, notes, and snippets.

@mebaysan
Created November 17, 2020 12:05
Show Gist options
  • Save mebaysan/d8ccca32c7d41ca8e00f8d8ef82be823 to your computer and use it in GitHub Desktop.
Save mebaysan/d8ccca32c7d41ca8e00f8d8ef82be823 to your computer and use it in GitHub Desktop.
Plotly Dash uygulamalarım için gelen parametrelere göre veri filtreleme fonksiyonu
import pandas as pd
DF = pd.read_csv('example.csv')
def data_filtrele(city, region, cat1, cat2, cat3, start_date, end_date):
filtered_df = DF
filtered_df = filtered_df[filtered_df['CITY'] == city] if city != 'Hepsi' else filtered_df
filtered_df = filtered_df[filtered_df['REGION'] == region] if region != 'Hepsi' else filtered_df
filtered_df = filtered_df[filtered_df['CATEGORY_NAME1'] == cat1] if cat1 != 'Hepsi' else filtered_df
filtered_df = filtered_df[filtered_df['CATEGORY_NAME2'] == cat2] if cat2 != 'Hepsi' else filtered_df
filtered_df = filtered_df[filtered_df['CATEGORY_NAME3'] == cat3] if cat3 != 'Hepsi' else filtered_df
filtered_df = filtered_df.query(f'DATE_ >= "{start_date}"').query(f'DATE_ <= "{end_date}"')
return filtered_df
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment