Create A Pandas Dataframe Right Inside Excel

Опубликовано: 29 Сентябрь 2024
на канале: Coding Is Fun

5,561

161

👉 𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗘 𝗙𝗥𝗘𝗘 𝗔𝗗𝗗-𝗜𝗡 𝗛𝗘𝗥𝗘: https://pythonandvba.com/mytoolbelt

𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🚨 PLEASE NOTE: Creating a Pandas Dataframe based on your Excel selection is only available in the PRO-Version (NOT FREE) 🚨

The add-in creates the Python code to correctly read in the excel file and construct the dataframe. Instead of messing around with all of the available options in the read_excel method, it does it for you. Particularly handy when the tables are formatted and have merged cells.

The add-in is written in VBA, and it will translate the cell range into the following pandas arguments:

• io [File Name]
• sheet_name
• skiprows [Number of lines to skip (int) at the start of the file]
• usecols [Excel column letters and column ranges (e.g. “A:E”)]
• nrows [Number of rows to parse]

📺 𝗙𝗨𝗟𝗟 𝗔𝗗𝗗-𝗜𝗡 𝗧𝗨𝗧𝗢𝗥𝗜𝗔𝗟:
►    • FREE Excel Add-in to Boost Your Produ...

𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): https://pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): https://pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): https://pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): https://pythonandvba.com/emojify
📑 Excel Templates: https://pythonandvba.com/go/excel-tem...
🎓 My Courses: https://pythonandvba.com/go/courses
📚 Books, Tools, and More: https://pythonandvba.com/resources

𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn:   / sven-bosau
📸 Instagram:   / codingisfun_official
💻 GitHub: https://github.com/Sven-Bo
💬 Discord: https://pythonandvba.com/discord
📬 Contact: https://pythonandvba.com/contact

☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here: https://pythonandvba.com/coffee-donation