Find Jobs
Hire Freelancers

Elegant and structure an Excel sheet with Python3

$10-30 CAD

进行中
已发布大约 6 年前

$10-30 CAD

货到付款
I have a standard Excel sheet '[login to view URL]' which I would like to restructure in three separates frames, i.e. 'Day Trading', 'Scalping' and 'Shorting'. The main title would be 'Best gainers'. I would like the end result gives me a worksheet stylish and elegant. Description: 1- Each frame and the title will be separated with one or two rows. 2- The main title is at the top and centered. The subtitles are at the top left of each frame. 3- The title bar needs to be inserted in each frame or it could be a followed title bar whenever we scroll down. 4- The columns would resize automatically according to the number of characters of each title column. Use resize_columns() class method from styling.py. 5- Each frame needs to be auto-adjustable in function of the number of rows. folding_rows() class method from [login to view URL] could be used to fix the maximum number of rows in each frame. 6- Each title would be styled. The style_ws() class method from [login to view URL] could be used for that task. 7- The title bar will be framed and the titles of each columns will be enlarged and bold. Be creative! :D P.S. Your best tool is probably pandas and openpyxl. I liked using writer = [login to view URL](filename, engine='openpyxl').
项目 ID: 16453291

关于此项目

1条提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
I am a data analyst I have over 3 years of experience with excel and python and numpy library if len(groups)!= len(weights): raise ValueError groups = [login to view URL](groups) weights = [login to view URL](weights) vals = [login to view URL](vals) means = [login to view URL]([login to view URL]) means[:] = [login to view URL] for k, g in enumerate(groups): if len(g) != len(vals): raise ValueError s = set(g) for c in s: index = [i for i, j in enumerate(g) if (j == c and not [login to view URL](vals[i]))] means[k, index] = [login to view URL](vals[index]) weighted_means = [login to view URL](means.T, weights) demanded = vals - weighted_means return demanded
$25 CAD 在1天之内
5.0 (2条评论)
1.5
1.5

关于客户

CANADA的国旗
Ste-Julie, Canada
5.0
13
付款方式已验证
会员自8月 1, 2017起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。