Automate Excel using Python | Excel Hacks with Pandas




[ad_1]

This video is about Excel Hacks with Pandas, automate Excel using python and how to split an excel file into multiple sheets. Also learn to excel hacks 2019

Here is the code on github: https://github.com/satssehgal/Excel_Splitter_Combiner/upload

👉 Patreon: patreon.com/SATSifaction
👉 Facebook Group: http://facebook.com/groups/theaiwarriors
👉 Instagram: @theaiwarriors
👉 Corporate Training and Up skilling: https://levers.ai

Netfirms (Affiliate) – https://bit.ly/2KdJ4Dp
Linode Server – https://bit.ly/2XpqGi9
Bluehost (Affiliate) – https://bit.ly/2GxxBh1
PythonAnywhere (Affiliate) – https://bit.ly/2kWORVe
Heroku – https://www.heroku.co
NordVPN (Affiliate) – https://bit.ly/2W87je0

Here is a link to my python for beginners, master python course: https://bit.ly/2HIZS42

Favourite Mobile Apps to Run Python and Code
iOS – Pythonista (paid) – https://apple.co/2HjRVTJ
Android – Dcoder (free) – https://bit.ly/2Vrjb6N

Song

Credit To Author

Support Cavardix Beats:
https://www.facebook.com/cavardix
https://soundcloud.com/cavardixbeats
https://www.instagram.com/cavardixbeats/
https://www.youtube.com/channel/UCmwf

—————————————————————–
Royalty Free Music – Shadows (Dark Underground Rap Beat Hip Hop Instrumental)
https://www.youtube.com/watch?v=9CO9gubqf04

Source


[ad_2]

Comment List

  • SATSifaction
    November 15, 2020

    This is great. thank you!

  • SATSifaction
    November 15, 2020

    Why are there two for loops in the sendtosheet function?

  • SATSifaction
    November 15, 2020

    Thanks for actually explaining, showing, and proving how this works.

  • SATSifaction
    November 15, 2020

    Thanks man, very clear. Also thanks for sharing. One doubt. The file merge follow some order for dates of that instance? or is all of the first category then all the second category and so on? of course you can sort it later on excel.

  • SATSifaction
    November 15, 2020

    Love it!!

  • SATSifaction
    November 15, 2020

    Where u wrote this script Visual studio or spider platform.

  • SATSifaction
    November 15, 2020

    Could u please share the sample Excel file?

  • SATSifaction
    November 15, 2020

    Very useful one … I could not access the code .. kindly email me to vsvenkatiyer@gmail.com

  • SATSifaction
    November 15, 2020

    This is a great tutorial! Got a sub in me now 😀

    Is there a link for that excel file for us to follow along? Don't see it on your Github

  • SATSifaction
    November 15, 2020

    This was really helpful. Thanks a lot !!

  • SATSifaction
    November 15, 2020

    Great video.

  • SATSifaction
    November 15, 2020

    Awesome, thank you! Although I would suggest casting the sheet names to strings, as I ran into type errors while trying out your script. But the rest was spot-on!

  • SATSifaction
    November 15, 2020

    Hi There. Great Tutorial. However if I use Atom editor to run this program I get this error after the file path is entered: Alexanders-Air:Excel_Splitter_Combiner-master lexi$ python combinefiles.py
    File Path: /Users/lexi/Downloads/Excel_Splitter_Combiner-master/N_Power_Split_Data/
    Traceback (most recent call last):
    File "combinefiles.py", line 5, in <module>

    file=input('File Path: ')
    File "<string>", line 1
    /Users/lexi/Downloads/Excel_Splitter_Combiner-master/N_Power_Split_Data/
    ^
    SyntaxError: invalid syntax

    In Jupyter notebook it works well, just cant find a way to get the combined excel out.

    Please help.

  • SATSifaction
    November 15, 2020

    while executing the splitfile the last part of the code gives an error saying "TypeError: sequence item 2: expected str instance, float found" kindly help.

  • SATSifaction
    November 15, 2020

    Hi, Thank you for the explanation..however i have couple of things i need help with.. 1) How to use filter / find and replace . 2) How to use text to columns delimiter 3) And deleting columns & rows…Hope you can help me with some tips….Much Appreciate 🙂

  • SATSifaction
    November 15, 2020

    I used to to this kind of tasks with VBA. I've started learning python and I love it, however, is there any advantadge of using python instead of VBA? I find that splitting data with the advanced filter function in Excel is already a very efficient way

  • SATSifaction
    November 15, 2020

    Do you have a Python class for beginners?

  • SATSifaction
    November 15, 2020

    thanks! when I run the code I get the error: Traceback (most recent call last):

      File "split.py", line 42, in <module>

        print("Your data will split based on these values {} and create {} files or sheets based on next selection. If you are ready to proceed please type 'Y' and hit enter. Hit 'N' to exit".format(', '.join(cols), len(cols)))

    TypeError: sequence item 0: expected str instance, float found

    joeymeijers@MBP-van-Joey-2 split % 

    how can I fix this?

  • SATSifaction
    November 15, 2020

    what is the point for the first (while True ) in the last cell , and thankyou

  • SATSifaction
    November 15, 2020

    thanks for sharing.. i am not able to find the combined file …

  • SATSifaction
    November 15, 2020

    You can do all this in 10 sec with power query

Write a comment