# Any equivalent of Google translate (like in gsheet) for DataFrames?

**URL:** <https://discourse.julialang.org/t/any-equivalent-of-google-translate-like-in-gsheet-for-dataframes/73904>\
**Category:** General Usage\
**Tags:** dataframes, big-data, nlp\
**Created:** [January 1, 2022, 8:13pm UTC](https://discourse.julialang.org/t/any-equivalent-of-google-translate-like-in-gsheet-for-dataframes/73904 "2022-01-01T20:13:38Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![rafael.guerra](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/rafael.guerra/32/216610_2.png) [@rafael.guerra](https://discourse.julialang.org/u/rafael.guerra)\
**Post date:** [January 2, 2022, 12:38am UTC](https://discourse.julialang.org/t/any-equivalent-of-google-translate-like-in-gsheet-for-dataframes/73904/3 "2022-01-02T00:38:35Z")

</div>

The `GoogleTrans.jl` package seems to be broken?

FWIW, the solution [posted here](https://discourse.julialang.org/t/how-to-use-google-translator-from-julia-level/33837/4) does work:

```julia
using HTTP, JSON, DataFrames

function gtranslate(text, targetlang, sourcelang = "auto")
    url = "https://translate.googleapis.com/translate_a/single?client=gtx&sl=" * sourcelang * "&tl=" * targetlang * "&dt=t&q=" * HTTP.escapeuri(text)
    result = JSON.parse(String(HTTP.request("GET", url).body))
    join([s[1] for s in result[1]], "")
end

messages = ["Hello Julia." "Thank you for everything"; "You are welcome!" "Bye now"]
df = DataFrame(messages, :auto)

 Row │ x1 x2
─────┼────────────────────────────────────────────
   1 │ Hello Julia. Thank you for everything
   2 │ You are welcome! Bye now

gtranslate.(df,"fr")

 Row │ x1 x2
─────┼────────────────────────────────────────────
   1 │ Bonjour Julia. Merci pour tout
   2 │ Je vous en prie! Et maintenant, au revoir

gtranslate.(df,"iw")

 Row │ x1 x2
─────┼───────────────────────────
   1 │ שלום ג'וליה. תודה על הכל
   2 │ בבקשה! להתראות

```

---

_[View the full topic](https://discourse.julialang.org/t/any-equivalent-of-google-translate-like-in-gsheet-for-dataframes/73904)._