当前位置:网站首页>SparkSQL 实验
SparkSQL 实验
2022-07-21 05:23:00 【花花王】
将下列JSON格式数据复制到Linux系统中,并保存命名为employee.json。
{ “id”:1 , “name”:" Ella" , “age”:36 }
{ “id”:2, “name”:“Bob”,“age”:29 }
{ “id”:3 , “name”:“Jack”,“age”:29 }
{ “id”:4 , “name”:“Jim”,“age”:28 }
{ “id”:4 , “name”:“Jim”,“age”:28 }
{ “id”:5 , “name”:“Damon” }
{ “id”:5 , “name”:“Damon” }
为employee.json创建DataFrame,并写出Python语句完成下列操作:
1)查询所有数据
并去除重复的数据
2)查询所有数据,打印时去除id字段;
3)筛选出age>30的记录;
4)将数据按age分组;
5)将数据按name升序排列
边栏推荐
- Some commands used in project implementation
- Deploy lvs-nat cluster
- When using jasperreports, reportexpressionevaluationdata exception is reported
- 环路接口实验
- OSPF的路由控制和防环
- ma.glasnost.orika.MappingException:No converter registered for conversion from Date to LocalDateTime
- Comparison table of ZH CN, en US, Zh TW and other language (Culture) codes with countries and regions
- RFC文档下载
- Ipset basic usage and save configuration
- VRRP虚拟路由冗余协议
猜你喜欢
[feature learning] feature learning based on deep learning and word embedding
Several methods of quickly checking the local public IP
【特征选择】特征选择的几种方法
TCP/IP五层和七层模型总结(建议全文背诵)
Go语言之if语句的特殊写法(if带分号;)
First acquaintance with JVM (I)
【基础数据挖掘技术】探索性数据分析
MATLAB读取csv文件里面既有文本又有数字的文件怎么读取。(可以不止csv文件,txt等文件都可以)
Kubectl get node appears when running: unable to connect to the server: x509: certificate signed by unknown authority
【基础数据挖掘技术】KNN简单聚类
随机推荐
【自然语言处理与文本分析】文本特征提取方法总结。关键词提取方法。公认效果较好的IDF,RCF。
scala安装
【 traitement du langage naturel et analyse de texte】 cet article présente la méthodologie de l'exploration de texte avec deux cas de projet.
【自然语言处理和文本分析】基本信息检索技术中的全面扫描法和逐项翻转法。
切换用户后,/etc/profile的配置不起效
lvm和磁盘配额
VRRP virtual routing Redundancy Protocol
Loop interface experiment
Several common login debugging methods
Form form label
Go语言之return语句深入理解及defer、return的执行顺序
Host information collection script
【进阶数据挖掘技术】进阶数据挖掘技术介绍
[natural language processing and text analysis] two sub models of word2vec (supervised neural network model), skip gram and cbow model.
Rip in routing
Summary of tcp/ip five layer and seven layer models (it is recommended to recite the full text)
HCIA总结
OSPF packet
How important is the instant debit system to B2B e-commerce business?
[natural language processing and text analysis] comprehensive scanning method and item by item flipping method in basic information retrieval technology.