blocks|key|1887001|text|我不知道有什么实际的转换，但假设您指的是DBC总线格式，有一个Python库可以读取：https://pypi.org/project/cantools/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1887002|而且Python还内置了编写CSVs的工具：https://docs.python.org/3/library/csv.html。|1887003|应该只需几行代码就可以将这些库组合成一个转换器。|1887004|entityMap|0|LINK|mutability|MUTABLE|url|https://pypi.org/project/cantools/|1|https://docs.python.org/3/library/csv.html^0|17|Y|0|0|M|16|1|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]]|C|$]]|$1|D|3|E|5|6|7|V|8|@]|9|@$A|W|B|X|1|Y]]|C|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|10|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]|P|$5|K|L|M|C|$N|Q]]]]

I don't know of anything that does an actual conversion, but assuming you mean the DBC BUS format, there's a Python library to read that: <a href="https://pypi.org/project/cantools/" rel="nofollow noreferrer">https://pypi.org/project/cantools/</a>

And Python has built-in tools for writing CSVs: <a href="https://docs.python.org/3/library/csv.html" rel="nofollow noreferrer">https://docs.python.org/3/library/csv.html</a>

It should take only a handful of lines to combine those libraries into a converter.

blocks|key|3418701|text|把它转换成XLS+(microsoft+)，然后从那里你可以得到它到.csv，我是一个ubuntu的家伙，但我相信应该有一个导出选项。或者至少在LibreOffice中有|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3418702|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Convert it to XLS (microsoft excel) and from there you can get it to .csv, I am ubuntu guy but I believe there should be a export option. or at least there is in LibreOffice

blocks|key|697597|text|我真的不明白为什么有些成员对这个问题给予-1，但没有真正回答。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|697598|好吧，我还没有找到一个很好的库来将.DBC转换为.CSV。但是我可以使用Python+%2BR实现它，我在这里分享我是如何实现它的。|offset|length|style|CODE|697599|下面的Python获取R路径并执行发送三个args的dbc2csv.R文件:原始文件路径、转换的文件路径和将要转换的文件名。|697600|import+subprocess
import+commands


def+dbc2csv(raw_filename):
dbc2csv_path+=+"/path/to/script/dbc2csv.R+"+%2B+raw_files_dir+%2B+"+"+%2B+converted_files_dir+%2B+"+"+%2B+raw_filename

try:
++++r_script_path+=+commands.getstatusoutput('which+Rscript')[1]
++++subprocess.call(r_script_path+%2B+"+--vanilla+"+%2B+dbc2csv_path,+shell=True)
++++return+True
except:
++++print("(Rscript)+Error+converting+file:+"+%2B+raw_filename)

return+False|code-block|syntax|javascript|697601|R脚本dbc2csv.R下面实际上是谁将转换。|697602|#install.packages("read.dbc")+You+need+this+package
library("read.dbc")


dbc2dbf+<-+function(rawDir,+convertedDir,+file)+{
++++#+reads+dbc+file
++++x+<-+read.dbc(paste(rawDir,+file,+sep=""))
++++#+write+it+to+csv
++++write.csv(x,+file=paste(convertedDir,+file,+".csv",+sep=""))
}

args+=+commandArgs(trailingOnly=TRUE)
try(dbc2dbf(args[1],+args[2],+args[3]),+TRUE)|697603|我们确实知道，如果我们只使用Python进行转换会更好。但这种方法会很好。|697604|entityMap^0|0|H|4|O|4|0|Q|9|0|0|3|9|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@$D|Y|E|Z|F|G]|$D|10|E|11|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|12|8|@$D|13|E|14|F|G]]|9|@]|A|$]]|$1|J|3|K|5|L|7|15|8|@]|9|@]|A|$M|N]]|$1|O|3|P|5|6|7|16|8|@$D|17|E|18|F|G]]|9|@]|A|$]]|$1|Q|3|R|5|L|7|19|8|@]|9|@]|A|$M|N]]|$1|S|3|T|5|6|7|1A|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|V|$]]

I really don't understand why some members give -1 to the question, but don't really answer it.

Well, I've not found out a good lib to convert <code>.DBC</code> to <code>.CSV</code>.
But I could do it using Python + R and I'm sharing here how I achieved it.

The Python script below gets R path and executes the <code>dbc2csv.R</code> file sending three args: the raw file path, converted file path, and the file name that will be converted.

<pre><code>import subprocess
import commands


def dbc2csv(raw_filename):
dbc2csv_path = "/path/to/script/dbc2csv.R " + raw_files_dir + " " + converted_files_dir + " " + raw_filename

try:
 r_script_path = commands.getstatusoutput('which Rscript')[1]
 subprocess.call(r_script_path + " --vanilla " + dbc2csv_path, shell=True)
 return True
except:
 print("(Rscript) Error converting file: " + raw_filename)

return False
</code></pre>

The R script <code>dbc2csv.R</code> bellow is actually who will convert.

<pre><code>#install.packages("read.dbc") You need this package
library("read.dbc")


dbc2dbf &lt;- function(rawDir, convertedDir, file) {
 # reads dbc file
 x &lt;- read.dbc(paste(rawDir, file, sep=""))
 # write it to csv
 write.csv(x, file=paste(convertedDir, file, ".csv", sep=""))
}

args = commandArgs(trailingOnly=TRUE)
try(dbc2dbf(args[1], args[2], args[3]), TRUE)
</code></pre>

We do know it would be better if we could convert using just Python.
But this approach will work fine.

blocks|key|3418816|text|如果您在Linux上使用python，其中一个替代方案是使用位于此存储库的项目：https://github.com/greatjapa/dbc2csv|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3418817|它的工作方式是创建一个用于运行bash脚本和python脚本的对接器(您也可以单独运行它们，而不需要使用docker，这也同样有效)。|3418818|还值得注意的是，Datasus使用的.dbc扩展是他们自己创建的(与cantools和其他类似工具使用的.dbc无关)，这只会帮助它成为一种痛苦的工作。|3418819|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/greatjapa/dbc2csv^0|14|10|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]]|C|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|C|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|C|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|I|$J|$5|K|L|M|C|$N|O]]]]

If you're using python on Linux, one of the alternatives is using the project located at this repository: <a href="https://github.com/greatjapa/dbc2csv" rel="nofollow noreferrer">https://github.com/greatjapa/dbc2csv</a>

It works by creating a docker that runs the bash script followed by the python script (you can also run them separately, without using docker, and that will work just as well).

It's also worth noting that the .dbc extension used by Datasus is one that they created themselves (not related to the .dbc used by cantools and other such tools), which just helps it being a pain to work with.

blocks|key|1887128|text|在python中有一个很棒的库https://pypi.org/project/cantools/|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1887129|您可以通过它的源代码找到您需要提取的字段：https://github.com/eerimoq/cantools/tree/f120d35e1523201b6d87e87306457bf1769330e3|1887130|在这个github链接中，所有消息和信号的相关字段都可以在cantools/database/+can+/message.py和/database/can/signal.py中找到。|1887131|如果你需要名字和信号单位，你可以使用signal.name和signal.unit|1887132|提取这些字段的示例代码：|1887133|+#**dbc_file**+is+the+full+path+of+dbc+
++++db+=+cantools.database.load_file(dbc_file)
++++for+msg+in+db.messages:
++++++++msg_name+=+msg.name
++++++++msg_id+=+msg.frame_id
++++++++msg_length+=+msg.length
++++++++sender+=+msg.senders
++++++++msg_group+=+db.get_message_by_name(msg_name)
++++
++++++++for+signal+in+msg_group.signals:
++++++++++++
++++++++++++#name+of+signal
++++++++++++sig_name+=+signal.name
++++++++++++#unit+of+signal
++++++++++++sig_unit+=+signal.unit|code-block|syntax|javascript|1887134|希望这能帮上忙！！|1887135|entityMap|0|LINK|mutability|MUTABLE|url|https://pypi.org/project/cantools/|1|https://github.com/eerimoq/cantools/tree/f120d35e1523201b6d87e87306457bf1769330e3^0|F|Y|0|0|L|29|1|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@$A|13|B|14|1|15]]|C|$]]|$1|D|3|E|5|6|7|16|8|@]|9|@$A|17|B|18|1|19]]|C|$]]|$1|F|3|G|5|6|7|1A|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|1B|8|@]|9|@]|C|$]]|$1|J|3|K|5|6|7|1C|8|@]|9|@]|C|$]]|$1|L|3|M|5|N|7|1D|8|@]|9|@]|C|$O|P]]|$1|Q|3|R|5|6|7|1E|8|@]|9|@]|C|$]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|C|$]]]|T|$U|$5|V|W|X|C|$Y|Z]]|10|$5|V|W|X|C|$Y|11]]]]

In python there is this awesome library <a href="https://pypi.org/project/cantools/" rel="nofollow noreferrer">https://pypi.org/project/cantools/</a>
You can go through the source code of it to find the fields you need to extract : <a href="https://github.com/eerimoq/cantools/tree/f120d35e1523201b6d87e87306457bf1769330e3" rel="nofollow noreferrer">https://github.com/eerimoq/cantools/tree/f120d35e1523201b6d87e87306457bf1769330e3</a>
All relevant fields for messages and signals can be found out in cantools/database/can/message.py and /database/can/signal.py in this github link
For eg: if you need names and unit of signals you could use signal.name and signal.unit
Sample code to extract these fields:
<pre><code> #**dbc_file** is the full path of dbc 
 db = cantools.database.load_file(dbc_file)
 for msg in db.messages:
 msg_name = msg.name
 msg_id = msg.frame_id
 msg_length = msg.length
 sender = msg.senders
 msg_group = db.get_message_by_name(msg_name)
 
 for signal in msg_group.signals:
 
 #name of signal
 sig_name = signal.name
 #unit of signal
 sig_unit = signal.unit
</code></pre>
Hope this might help someone!!

I'm writing a python script to convert <code>.DBC</code> files (from Datasus) into <code>.CSV</code>.

I've searched a lot some libs to help me but didn't get success with any of them. Do someone know an option/package which could be useful in this conversion task?

Convert .dbc files into .csv with python

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

我正在编写一个python脚本，将.DBC文件(从Datasus)转换为.CSV。我已经找了很多朋友来帮我，但是他们都没有成功。有人知道在这个转换任务中可能有用的选项/包吗？

问用python将.dbc文件转换为.csv
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用python将.dbc文件转换为.csvEN