//字段调整
select 学号 AS 学号,
姓名 AS 姓名,
性别 AS 性别,
籍贯 AS 籍贯,
宿舍 AS 宿舍,
A1#A AS 朋友圈,
A1#B AS 个人兴趣,
A1#C AS 热点,
A1#D AS 专业学习,
A1#E AS 上网习惯,
A1#F AS 猎奇,
A2#A AS 内容合理,
A2#B AS 图片视频,
A2#C AS 有人证实,
A2#D AS 权威发布,
A2#E AS 自身判断,
A2#F AS 网络热度,
A2#G AS 其他,
A3 AS 性格,
B1#A AS 实习渠道,
B1#B AS 转基因渠道,
B1#C AS 交流生渠道,
F23 AS  信息源,
B2#A AS 实习源类,
B2#B AS 转基因类,
B2#C AS 交流生类,
B3#A AS 实习初始信度,
B3#B AS 转基因初始信度,
B3#C AS 交流生初始信度,
B4#A AS 实习初始感觉,
B4#B AS 转基因初始感觉,
B4#C AS 交流生初始感觉,
B5#A AS 实习观点影响,
B5#B AS 转基因观点影响,
B5#C AS 交流生观点影响,
B6#A AS 实习求证方式,
B6#B AS 转基因求证方式,
B6#C AS 交流生求证方式,
C1 AS 实习内容关注,
C2 AS 转基因内容关注,
C3 AS 交流生内容关注,
C4#A AS 实习处理,
C4#B AS 转基因处理,
C4#C AS 交流生处理,
C5#A AS 实习传播渠道,
C5#B AS 转基因传播渠道,
C5#C AS 交流生传播渠道,
C6#A AS 实习交流对象,
C6#B AS 转基因交流对象,
C6#C AS 交流生交流对象,
C7#A AS 实习传播动机,      
C7#B AS 转基因传播动机,    
C7#C AS 交流生传播动机,    
C8#A AS 实习信息编辑,  
C8#B AS 转基因信息编辑,
C8#C AS 交流生信息编辑,
C9#A AS 实习群体态度,  
C9#B AS 转基因群体态度,
C9#C AS 交流生群体态度,
C10#A AS 实习群体一致,  
C10#B AS 转基因群体一致,
C10#C AS 交流生群体一致,
C11#A AS 实习持续关注,  
C11#B AS 转基因持续关注,
C11#C AS 交流生持续关注,
C12 AS 观点转变,
C13 AS 观点对立,
D1#A AS 实习终信度,
D1#B AS 转基因终信度,
D1#C AS 交流生终信度,
D2 AS 应对不实行为,
D3 AS 澄清方式

FROM dbo.问卷数据

//内容转化
select 学号 AS 学号,
姓名 AS 姓名,
性别 AS 性别,
籍贯 AS 籍贯,
宿舍 AS 宿舍,
朋友圈 AS 朋友圈,
个人兴趣 AS 个人兴趣,
热点 AS 热点,
专业学习 AS 专业学习,
上网习惯 AS 上网习惯,
猎奇 AS 猎奇,
内容合理 AS 内容合理,
图片视频 AS 图片视频,
有人证实 AS 有人证实,
权威发布 AS 权威发布,
自身判断 AS 自身判断,
网络热度 AS 网络热度,
其他 AS 其他,
性格 AS 性格,
实习渠道 AS 实习渠道,
转基因渠道 AS 转基因渠道,
交流生渠道 AS 交流生渠道,
信息源 AS  信息源,
实习源类 AS 实习源类别,
转基因类 AS 转基因类别,
交流生类 AS 交流生类别,
case when 实习初始信度=1 then 1
when 实习初始信度=2 then 1
when 实习初始信度=3 then 0
 when 实习初始信度=4 then 0
when 实习初始信度=5 then 0

end
 AS 实习初始信度,
 case when 转基因初始信度=1 then 1
when 转基因初始信度=2 then 1
when 转基因初始信度=3 then 0
 when 转基因初始信度=4 then 0
when 转基因初始信度=5 then 0
end
 AS 转基因初始信度,
  case when 交流生初始信度=1 then 1
when 交流生初始信度=2 then 1
when 交流生初始信度=3 then 0
 when 交流生初始信度=4 then 0
when 交流生初始信度=5 then 0
end
AS 交流生初始信度,
实习初始感觉 AS 实习初始感觉,
转基因初始感觉 AS 转基因初始感觉,
交流生初始感觉 AS 交流生初始感觉,
实习观点影响 AS 实习观点影响,
转基因观点影响 AS 转基因观点影响,
交流生观点影响 AS 交流生观点影响,
实习求证方式 AS 实习求证方式,
转基因求证方式 AS 转基因求证方式,
交流生求证方式 AS 交流生求证方式,
实习内容关注 AS 实习内容关注,
转基因内容关注 AS 转基因内容关注,
交流生内容关注 AS 交流生内容关注,
实习处理 AS 实习处理,
转基因处理 AS 转基因处理,
交流生处理 AS 交流生处理,
实习传播渠道 AS 实习传播渠道,
转基因传播渠道 AS 转基因传播渠道,
交流生传播渠道 AS 交流生传播渠道,
实习交流对象 AS 实习交流对象,
转基因交流对象 AS 转基因交流对象,
交流生交流对象 AS 交流生交流对象,
实习传播动机 AS 实习传播动机,      
转基因传播动机 AS 转基因传播动机,    
交流生传播动机 AS 交流生传播动机,    
实习信息编辑 AS 实习信息编辑,  
转基因信息编辑 AS 转基因信息编辑,
交流生信息编辑 AS 交流生信息编辑,
实习群体态度 AS 实习群体态度,  
转基因群体态度 AS 转基因群体态度,
交流生群体态度 AS 交流生群体态度,
实习群体一致 AS 实习群体一致,  
转基因群体一致 AS 转基因群体一致,
交流生群体一致 AS 交流生群体一致,
实习持续关注 AS 实习持续关注,  
转基因持续关注 AS 转基因持续关注,
交流生持续关注 AS 交流生持续关注,
观点转变 AS 观点转变,
观点对立 AS 观点对立,
 case when 实习终信度=1 then 1
when 实习终信度=2 then 1
when 实习终信度=3 then 0
 when 实习终信度=4 then 0
when 实习终信度=5 then 0
end
实习终信度 AS 实习终信度,
 case when 转基因终信度=1 then 1
when 转基因终信度=2 then 1
when 转基因终信度=3 then 0
 when 转基因终信度=4 then 0
when 转基因终信度=5 then 0
end
转基因终信度 AS 转基因终信度,
 case when 交流生终信度=1 then 1
when 交流生终信度=2 then 1
when 交流生终信度=3 then 0
 when 交流生终信度=4 then 0
when 交流生终信度=5 then 0
end
交流生终信度 AS 交流生终信度,
应对不实行为 AS 应对不实行为,
澄清方式 AS 澄清方式

FROM dbo.问卷清洗