Скачать или смотреть Amazing way to split data in different Worksheet in Excel using Python.

Welcome to ExcelVBA Expert, your go-to channel for mastering a range of technologies, including Excel, VBA, SQL, Power BI, Microsoft Forms, Google Forms, Power Apps, Power Automate, SharePoint List, Power Query, Power Pivot, and Python.

Dive into our video tutorials where we explore Data Analytics, unraveling the intricacies of extracting valuable insights from raw data using various technologies. Whether you are a beginner or an experienced professional, our content caters to all skill levels.

Join our vibrant community of ExcelVBA experts by hitting that subscribe button. Your journey to becoming proficient in diverse technologies begins here. Thanks for dropping by!

To stay connected, feel free to join our WhatsApp group through the link below:
WhatsApp Link: https://www.youtube.com/redirect?even...

For any inquiries or collaboration, reach out to us at [email protected].

Explore our Playlists:

VBA Playlist:    • Read the outlook Mails from Desktop folder...  
Excel Playlist:    • 5 Pivot Table Tips & Tricks.  
SQL Playlist:    • Connectivity of SQL & Excel using VBA  
MIS Test Paper Playlist:    • MIS Test Paper -2 in Hindi #Excelvba exper...  
Embark on your learning journey with ExcelVBA Expert—where technology meets expertise!

Python Code :

"import pandas as pd
from openpyxl import writer

df=pd.read_excel('Masterdata.xlsx')

Agent = df['Agent'].unique()

with pd.ExcelWriter('Agentwise data.xlsx',engine='openpyxl') as writer:
for x in Agent:
df1 = df[df['Agent']==x]
df1.to_excel(writer,sheet_name=x,index=False)
writer.save()

"