Skip to content

Instantly share code, notes, and snippets.

View softserveslayer's full-sized avatar

Jaime Cheng softserveslayer

View GitHub Profile
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width,initial-scale=1">
<title>dbt migration sequencer</title>
<style>
*{box-sizing:border-box;margin:0;padding:0}
body{font-family:-apple-system,BlinkMacSystemFont,'Segoe UI',sans-serif;background:#f5f5f2;color:#1a1a18;font-size:14px;line-height:1.5}
.page{max-width:900px;margin:0 auto;padding:1.5rem 1rem}
df['category']=np.where(df['category'] =="Women's Apparel", 'Apparel_Shoes', df['category'])
df['category']=np.where(df['category'] =="Men and Women's Apparel", 'Apparel_Shoes', df['category'])
df['category']=np.where(df['category'] =="Baby and Children's Apparel and Accessories", 'Apparel_Shoes', df['category'])
df['category']=np.where(df['category'] =="Undergarments and Basics", 'Apparel_Shoes', df['category'])
df['category']=np.where(df['category'] =="Men and Women's Shoes", 'Apparel_Shoes', df['category'])
df['category']=np.where(df['category'] =="Costumes", 'Apparel_Shoes', df['category'])
df['category']=np.where(df['category'] =="Women's Shoes", 'Apparel_Shoes', df['category'])
df['category']=np.where(df['category'] =="Fitness Programs", 'Fitness_Health', df['category'])
df['category']=np.where(df['category'] =="Fitness Apparel and Accessories", 'Fitness_Health', df['category'])
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@softserveslayer
softserveslayer / user_profiles.py
Created October 18, 2018 19:52
Create User Profiles in SQL
columns = ['TV',
'Politics-Domestic',
'Movies',
'Music',
'Celebrity',
'Feminism-Politics-Identity',
'Culture-Media',
'Celebrity',
'Culture-Media',
'Beauty',