<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[linglish的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/linglish</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; linglish]]></copyright><item><title><![CDATA[【SQL】电商用户行为分析]]></title><link>https://blog.youkuaiyun.com/linglish/article/details/124556286</link><guid>https://blog.youkuaiyun.com/linglish/article/details/124556286</guid><author>linglish</author><pubDate>Wed, 04 May 2022 22:32:24 +0800</pubDate><description><![CDATA[一、项目背景及目的


1.1 项目背景

移动互联网企业从粗放式到精细化运营管理过程中，需要结合市场、渠道、用户行为等数据分析，对用户开展有针对性的运营活动，提供个性化、差异化的运营策略，以实现运营业务指标。本项目利用sql对淘宝用户行为数据进行分析，通过用户行为分析业务问题，提供针对性的运营策略。

1.2 项目目的

通过对淘宝用户行为数据分析，为以下问题提供解释和改进建议：
1、分析用户使用APP过程中的常见电商分析指标，建立用户行为转化漏斗模型，确定各个环节的流失率，找到需要改进的环节
2、研究用]]></description><category></category></item><item><title><![CDATA[2020年1-6月全球新冠病毒确诊数据]]></title><link>https://blog.youkuaiyun.com/linglish/article/details/124229646</link><guid>https://blog.youkuaiyun.com/linglish/article/details/124229646</guid><author>linglish</author><pubDate>Sun, 17 Apr 2022 14:58:11 +0800</pubDate><description><![CDATA[页面--精确日期，进行以天为单位动态展示数据。



PS：tableau页面不能动态播放的解决方法：格式设置--动画--关闭。


]]></description><category></category></item><item><title><![CDATA[电商销售数据分析]]></title><link>https://blog.youkuaiyun.com/linglish/article/details/124157733</link><guid>https://blog.youkuaiyun.com/linglish/article/details/124157733</guid><author>linglish</author><pubDate>Wed, 13 Apr 2022 21:37:47 +0800</pubDate><description><![CDATA[# 导入模块
import pandas as pd
import matplotlib.pyplot as plt
# 读取csv文件
df2019= pd.read_csv("/Users/Lily/2019年下半年订单表.csv")
df2020= pd.read_csv("/Users/Lily/2020年上半年订单表.csv")
# 使用pd.concat()函数纵向合并df2019、df2020
dfYear= pd.concat([df2019,df2020])

# 将"下单时间"...]]></description><category></category></item><item><title><![CDATA[视频会员订单数据清洗]]></title><link>https://blog.youkuaiyun.com/linglish/article/details/124136826</link><guid>https://blog.youkuaiyun.com/linglish/article/details/124136826</guid><author>linglish</author><pubDate>Tue, 12 Apr 2022 23:15:01 +0800</pubDate><description><![CDATA[使用pandas对订单数据进行清洗]]></description><category></category></item><item><title><![CDATA[Excel“爬取“3000套房源]]></title><link>https://blog.youkuaiyun.com/linglish/article/details/124134011</link><guid>https://blog.youkuaiyun.com/linglish/article/details/124134011</guid><author>linglish</author><pubDate>Tue, 12 Apr 2022 21:45:45 +0800</pubDate><description><![CDATA[Excel处理3000套房源信息]]></description><category></category></item><item><title><![CDATA[销售数据仪表盘-PowerBi]]></title><link>https://blog.youkuaiyun.com/linglish/article/details/123998455</link><guid>https://blog.youkuaiyun.com/linglish/article/details/123998455</guid><author>linglish</author><pubDate>Thu, 07 Apr 2022 16:56:21 +0800</pubDate><description><![CDATA[You as a BI data analyst need to prepare a management report to the management team and explain the sales performance across different markets, top-selling products and sales development. How would you like to proceed with this?]]></description><category></category></item></channel></rss>