Youhu - Wuthering Waves
2024.11.28 05:40 Rengginangasoy Youhu - Wuthering Waves
submitted by Rengginangasoy to fanart [link] [comments]
2024.11.28 05:40 bawesome2424 Competitive Wariors... How Do You Do It?
I'll admit. I am a quick play warrior. I love playing woth my sister, who, although close to my level (silver 3ish), find a lot of stress and struggle when playing comp with me (gold 3). So I play quick play with her, and have a lot of fun.
But every so often, I try to jump into some comp by myself. And it is such a TERRIBLE experience. I hardly ever have a close game. The wins feel bad, and the losses feel even worse. I'm betting flamed by my 0-4 tank for "not getting enough kills as dps". I'll have 1 bad game where I am simply out played, and get obliterated in chat for being "trash." It's not fun.
However. I know there are people out there who play nothing but comp... how? How do you deal with the constant flaming? The massive win-loss streaks? The rank demotions? I'm genuinely curious how you keep coming back to this mode.
submitted by bawesome2424 to Overwatch [link] [comments]
2024.11.28 05:40 Sweet_Day_4561 Not sure if I should sign a longer, cheaper or shorter more expensive lease, I will beak it early either way
I have two options for lease renewal: 15 months at $1800 per month, or 12 months at $2000 per month. Let's say I will break the lease prematurely and move out after 6 months.
Regardless of the lease term, the penalties for breaking the lease are two months of rent.
I think the better choice here is 15 months, since I'm overall paying less money than the 12 month lease. But I just want to see if there are any ramifications I haven't thought of.
submitted by Sweet_Day_4561 to Advice [link] [comments]
2024.11.28 05:40 Alternative3860 Desperate Help needed in Automating Inventory Calculation with Python
Hi everyone! I’m stuck trying to automate a process I currently do manually in Excel. I’ve tried 100+ times but can’t seem to get it right.
The goal is to calculate the Runrate and Days of Cover (DOC) for inventory across cities, based on sales and stock data, and output the results in Excel. Here's how I do it manually:
This is how I do it manually in excel!
I first pivot the sales data (which includes columns like item_id, item_name, City, and quantity_sold) by item_id and item_name as rows and City as columns, with quantity_sold as the values. This gives me the total quantity sold per city. Then, I calculate the Runrate for each city using the formula: Runrate = Total Quantity Sold / Number of Days.
Next, I pivot the stock data (with columns item_id, item_name, City, backend_inventory, and frontend_inventory) in the same way, combining backend_inventory and frontend_inventory to get the Total Inventory per city: Total Inventory = backend_inventory + frontend_inventory.
Finally, I use a VLOOKUP to pull the Runrate from the sales pivot and combine it with the stock pivot. I calculate the Days of Cover (DOC) using the formula: DOC = Total Inventory / Runrate.
What I am trying to build is that python takes the recent data depending on a timestamp from a folder, pivots the data, calculate the Runrate and DOC and gives the output in a specified folder.
Here’s the Python code I’ve been trying, but I can’t get it to work. Any help or suggestions would be super appreciated!
import os
import glob
import pandas as pd
## Function to get the most recent file
data_folder = r'C:\Users\HP\Documents\data'
output_folder = r'C:\Users\HP\Documents\AnalysisOutputs'
## Function to get the most recent file
def get_latest_file(file_pattern):
files = glob.glob(file_pattern)
if not files:
raise FileNotFoundError(f"No files matching the pattern {file_pattern} found in {os.path.dirname(file_pattern)}")
latest_file = max(files, key=os.path.getmtime)
print(f"Latest File Selected: {latest_file}")
return latest_file
# Ensure output folder exists
os.makedirs(output_folder, exist_ok=True)
# # Load the most recent sales and stock data
latest_stock_file = get_latest_file(f"{data_folder}/stock_data_*.csv")
latest_sales_file = get_latest_file(f"{data_folder}/sales_data_*.csv")
# Load the stock and sales data
stock_data = pd.read_csv(latest_stock_file)
sales_data = pd.read_csv(latest_sales_file)
# Add total inventory column
stock_data['Total_Inventory'] = stock_data['backend_inv_qty'] + stock_data['frontend_inv_qty']
# Normalize city names (if necessary)
stock_data['City_name'] = stock_data['City_name'].str.strip()
sales_data['City_name'] = sales_data['City_name'].str.strip()
# Create pivot tables for stock data (inventory) and sales data (run rate)
stock_pivot = stock_data.pivot_table(
index=['item_id', 'item_name'],
columns='City_name',
values='Total_Inventory',
aggfunc='sum'
).add_prefix('Inventory_')
sales_pivot = sales_data.pivot_table(
index=['item_id', 'item_name'],
columns='City_name',
values='qty_sold',
aggfunc='sum'
).div(24).add_prefix('RunRate_') # Calculate run rate for sales
# Flatten the column names for easy access
stock_pivot.columns = [col.split('_')[1] for col in stock_pivot.columns]
sales_pivot.columns = [col.split('_')[1] for col in sales_pivot.columns]
# Merge the sales pivot with the stock pivot based on item_id and item_name
final_data = stock_pivot.merge(sales_pivot, how='outer', on=['item_id', 'item_name'])
# Create a new DataFrame to store the desired output format
output_df = pd.DataFrame(index=final_data.index)
# Iterate through available cities and create columns in the output DataFrame
for city in final_data.columns:
if city in sales_pivot.columns: # Check if city exists in sales pivot
output_df[f'{city}_inv'] = final_data[city] # Assign inventory (if available)
else:
output_df[f'{city}_inv'] = 0 # Fill with zero for missing inventory
output_df[f'{city}_runrate'] = final_data.get(f'{city}_RunRate', 0) # Assign run rate (if available)
output_df[f'{city}_DOC'] = final_data.get(f'{city}_DOC', 0) # Assign DOC (if available)
# Add item_id and item_name to the output DataFrame
output_df['item_id'] = final_data.index.get_level_values('item_id')
output_df['item_name'] = final_data.index.get_level_values('item_name')
# Rearrange columns for desired output format
output_df = output_df[['item_id', 'item_name'] + [col for col in output_df.columns if col not in ['item_id', 'item_name']]]
# Save output to Excel
output_file_path = os.path.join(output_folder, 'final_output.xlsx')
with pd.ExcelWriter(output_file_path, engine='openpyxl') as writer:
stock_data.to_excel(writer, sheet_name='Stock_Data', index=False)
sales_data.to_excel(writer, sheet_name='Sales_Data', index=False)
stock_pivot.reset_index().to_excel(writer, sheet_name='Stock_Pivot', index=False)
sales_pivot.reset_index().to_excel(writer, sheet_name='Sales_Pivot', index=False)
final_data.to_excel(writer, sheet_name='Final_Output', index=False)
print(f"Output saved at: {output_file_path}")
The output I’m getting is the
| Dehradun_x | Delhi_x | Goa_x | Dehradun_y | Delhi_y | Goa_y |
|---|---|---|---|---|---|
| 319 | 1081 | 21 | 0.083333333 | 0.789402 | 0.27549 |
| 69 | 30 | 20 | 2.541666667 | 0.458333333 | 0.166667 |
The output I want is:
| Item_id | Item_name | Dehradun_inv | Dehradun_runrate | Dehradun_DOC | Delhi_inv | Delhi_runrate | Delhi_DOC |
|---|---|---|---|---|---|---|---|
| 123 | abc | 38 | 0.083333333 | 456 | 108 | 0.789402 | 136.8124 |
| 345 | bcd | 69 | 2.541666667 | 27.14754098 | 30 | 0.458333333 | 65.45455 |
2024.11.28 05:40 SillyGayFemboy_TuT make me blushh (incredibly easy) :P
 | i swear its gonna be harder to get a 0 than a 100 XD submitted by SillyGayFemboy_TuT to boykisser2 [link] [comments] |
2024.11.28 05:40 PartRevolutionary807 I was getting married and my close colleagues organised bachelor party. I was surprised to hear that kajal was attending, so I talked to guys and asked them to ditch the party without informing kajal, So that I can gain sympathy from her and have fun for one last time before my marriage...
 | submitted by PartRevolutionary807 to BollyGlamandRP [link] [comments] |
2024.11.28 05:40 JCwraps RizzNYears 🙌
 | Posted about this earlier! They made that X and twitter! I’m happy I’m in! Let’s grow the community and have a hell of a new year 🙌 submitted by JCwraps to SolanaMemeCoins [link] [comments] |
2024.11.28 05:40 Anubiz1_ Tattoo disaster's
 | This is just plain mind numbing?! WTAF?! submitted by Anubiz1_ to religiousfruitcake [link] [comments] |
2024.11.28 05:40 canadian-weed How-to use the Dremel Keyless Chuck 4486 - YouTube
 | submitted by canadian-weed to cryptogeum [link] [comments] |
2024.11.28 05:40 Double_Difficulty_53 There is a sale on steam right now
Can someone please explain to be what is the difference between base, Beyond Dawn, Beyond Dawn Deluxe and Beyond Dawn Ultimate editions of Tales of Arise.
Also, if you buy one version can you later upgrade it to another one? Let's just you buy the Deluxe edition and you later want to upgrade it to Definitive, is it possibke to do and only pay the difference in price between the 2 versions?
submitted by Double_Difficulty_53 to tales [link] [comments]
2024.11.28 05:40 supermax2008 Thought I would ask here since there are many pokeman fans here. What's the best old pokemon game that is a must play?
Hi guys and gals, thought this would be the best place to ask since u lot are quite knowledgeable on nintendo games and specifically pokemon. After plating arceus, I'm planning to download an emulator on my phone (android) to play the old pokemon games? I'd like to stick to the best of the best and I've heard a lot of good things about emerald. But I thought I'd get your opinion before I begin
submitted by supermax2008 to Switch [link] [comments]
2024.11.28 05:40 Psii828 Made this one for the boys
 | Tears over beers might as well be 4 beers in, if anyone got a better song for that lmk https://open.spotify.com/playlist/6ekjOFSw0qX4arfax4x0zI?si=qsC646exQ3ebVRMU03kCjA&pi=u-ynBXvjoIR2ea submitted by Psii828 to weirdspotifyplaylists [link] [comments] |
2024.11.28 05:40 Apprehensive-Tip3828 The moment I lost respect for Carmela
As a female audience, I always had a soft spot for Carmela and felt sorry for her to some degree. But as the show continues, we’re able to see how complicit and fucked up she is as well.
However, the moment I definitely started to see her differently was in season 2 episode 8: Full Leather Jacket. The way she barged into Joan’s office for the recommendation letter was it for me. I had this inclination to slap her—woman to woman. Or splash water at her place. The way that moment focused on her threatening Joan was awfully similar to how Tony and company got what they wanted, just minus the violence and swearing. Good parallels.
submitted by Apprehensive-Tip3828 to thesopranos [link] [comments]
2024.11.28 05:40 Consistent-Neat4218 https://onlymeth.com/RF256788587
https://onlymeth.com/RF256788587 https://richdaddy9.com/RF257112A00 https://melspin.com/RF208228617 https://imperium88.com/RF8932851
submitted by Consistent-Neat4218 to payidpokiesnew [link] [comments]
2024.11.28 05:40 CreativeOblivion My (25M) bf doesn’t wanna do anything anymore with me (24f)
I feel so awkward making this post lol. But recently I feel like every time I ask my bf for sex or just to mess around (even just like masturbate together and watch porn or something)he either doesn’t want to or just is like “sure” like it’s an obligatory thing.
We’ve been together 4 years and before we lived together I felt like we were doing it every time we were together, but now that we have lived together since February I just feel like our sex life has decline. Like we still mess around but I always have to ask or initiate. And sometimes when I’m trying to imitate without asking I feel like he acts stupid and oblivious? I’ll have my face literally in his lap or be touching him but he “won’t know” that’s what I wanted. Or I’ll purposely bend over and front of him or change in front of him and get no reaction.
I’ve brought it up and he just says that he sees me every day now and work is stressful etc and it’s just not at the front of his mind. He reassures me he loves me and says all the right things he just doesn’t think about sex as much as me. I’m pregnant and I think I’m just emotional because of that but I also felt this way before that as well because I felt like he wasn’t as into it.
He’s very sweet and 100% perfect everywhere else and always assured me that he’s still attracted to me and loves me etc but I honestly am just starting to hate asking and it makes me sad that he doesn’t want to. It makes me feel unattractive and undesirable, especially being pregnant.
What should I do? Should I stop asking? Be less sexually available in hopes he might come into me instead? I miss our sex life and I want to help get it back lol
submitted by CreativeOblivion to DeadBedrooms [link] [comments]
2024.11.28 05:40 mambococo Financial Crime Investigation/Forensic Experience
Has anyone worked in these types of roles, and can share their experience please?
Is the work very repetitive and demanding of hours? What is career progression like?
submitted by mambococo to auscorp [link] [comments]
2024.11.28 05:40 JackfruitMain2230 discount tire black friday / cyber monday deals 2024
hey guys, i just bought a new car and I’m looking to get a great deal on new tires this Black Friday. I’ve heard good things about Discount Tire and was wondering if anyone has experience with their Black Friday sales or promotions. if you’ve bought tires from Discount Tire before, what should I be looking for in terms of quality and price? Are there any specific deals, discounts, or promotions I should watch out for this Black Friday to get the best deal on tires?
submitted by JackfruitMain2230 to Tiresaretheenemy [link] [comments]
2024.11.28 05:40 m88vbb Let’s cum hard for skinnytight bikini bodies💓
05cae640ef1aed42b0cb0ad190810fe6929e9a60976514ef2c51859491efbdff5a
submitted by m88vbb to Snapchatgerman [link] [comments]
2024.11.28 05:40 SlimFlippant Impulse bought these and now I can’t figure out how to style them, pls help lol
 | submitted by SlimFlippant to mensfashion [link] [comments] |
2024.11.28 05:40 flameboi900 news an interests gone after update windows 10
 | submitted by flameboi900 to WindowsHelp [link] [comments] |
2024.11.28 05:40 Cultural_Manner_2198 Rate my List
Repentance in Death (995 points)
CHARACTERS
Death Korps Marshal (75 points)
• Warlord
• 1x Plasma pistol
1x Power weapon
• Enhancement: Grand Strategist
Death Rider Squadron Commander (60 points)
• 1x Bolt pistol
1x Death Rider hunting lance
1x Savage claws
BATTLELINE
Death Korps of Krieg (65 points)
• 1x Death Korps Watchmaster
• 1x Bolt pistol
1x Chainsword
• 9x Death Korps Trooper
• 9x Close combat weapon
1x Death Korps Medi-pack
6x Lasgun
1x Meltagun
1x Plasma gun
1x Sniper rifle
Death Korps of Krieg (65 points)
• 1x Death Korps Watchmaster
• 1x Chainsword
1x Plasma pistol
• 9x Death Korps Trooper
• 9x Close combat weapon
1x Death Korps Medi-pack
7x Lasgun
1x Meltagun
1x Sniper rifle
1x Vox-caster
Death Korps of Krieg (65 points)
• 1x Death Korps Watchmaster
• 1x Chainsword
1x Plasma pistol
• 9x Death Korps Trooper
• 9x Close combat weapon
1x Death Korps Medi-pack
1x Grenade launcher
6x Lasgun
1x Plasma gun
1x Sniper rifle
DEDICATED TRANSPORTS
Chimera (70 points)
• 1x Armoured tracks
1x Chimera multi-laser
1x Heavy bolter
1x Heavy stubber
1x Hunter-killer missile
1x Lasgun array
OTHER DATASHEETS
Death Rider Squadron (70 points)
• 1x Ridemaster
• 1x Death Rider hunting lance
1x Plasma pistol
1x Savage claws
• 4x Death Rider
• 4x Death Rider hunting lance
4x Laspistol
4x Savage claws
Earthshaker Carriage Battery (120 points)
• 1x Battery close combat weapons
1x Earthshaker cannon
Earthshaker Carriage Battery (120 points)
• 1x Battery close combat weapons
1x Earthshaker cannon
Hellhound (115 points)
• 1x Armoured tracks
1x Heavy flamer
1x Hunter-killer missile
1x Inferno cannon
Leman Russ Battle Tank (170 points)
• 1x Armoured tracks
1x Heavy stubber
1x Hunter-killer missile
1x Lascannon
1x Leman Russ battle cannon
2x Plasma cannon
submitted by Cultural_Manner_2198 to TheAstraMilitarum [link] [comments]
2024.11.28 05:40 camberi002 Motilpro - Uk - where to buy
Where do people buy Motilpro in order to get it in the UK ?
Also are there any other motility drugs other than Motilpro and motility activator ( a rotate between these ) that are proven to help with motility ?
submitted by camberi002 to SIBO [link] [comments]
2024.11.28 05:40 TheGoonReview A new spin on the legendary sword in the stone. We all search for something. May you find what you are looking for. Unlike this sword.
The Astralethra Project is a worldbuilding endeavor set in a unique, high-fantasy universe. While it embraces the familiar magic and wonder of a medieval fantasy setting, we're weaving in deep, intricate lore and even touches of science to create a world that stands apart—all while being fully compatible with D&D 5e! This project is being developed by me (The artist) and a small, talented team of writers and RPG designers. It's still in the early stages, so while we can't share too many specifics just yet, we welcome any and all questions! If you'd like to follow the journey and see more of the project's progress, you can follow me here on reddit or check out our BRAND NEW TOTALLY FREE PATREON HERE!
The Goodberry Grimoire
The Goodberry Grimoire has all of the things we’ve created including some we haven't posted here and like I said it's totally free. You get all the content with a free membership. So I hope you will check it out! It would mean the world to us. Until next time however i hope you all have a safe and wonderful day!
submitted by TheGoonReview to worldbuilding [link] [comments]
2024.11.28 05:40 Dense-Equal-9969 FEIN and HOLD https://dexscreener.com/solana/FktaMRhhVqPTxoBXBnKy8soJus3HhLRaptw4V1RnqtLf
submitted by Dense-Equal-9969 to Moonshotcoins [link] [comments]
2024.11.28 05:40 GameZedd01 Let's help each other find smaller bands and help them grow. What band do you listen to that has the least listeners would you recommend to others reading this post?
 | submitted by GameZedd01 to MetalMemes [link] [comments] |