Using v0.5.0
I have two different 10,000 line CSV files that I am reading into two
different dataframe variables using the readtable function.
Each table has in common a ten digit account_number that I would like to
use as an index and join into one master file.
Here is the account number example in the original CSV from file1:
8018884596
8018893530
8018909633
When I do a readtable of this CSV into file1 then do a*
typeof(file1[:account_number])* I get:
*DataArrays.DataArray(Int32,1)*
-571049996
-571041062
-571024959
when I do a
*typeof(file2[:account_number])*
*DataArrays.DataArray(String,1)*
*Question: *
My CSV files give no guidance that account_number should be Int32 or string
type. How do I force it to make both account_number elements type String?
I would like this join command to work:
*new_account_join = join(file1, file2, on =:account_number,kind = :left)*
But I am getting this error:
*ERROR: TypeError: typeassert: expected Union{Array{Symbol,1},Symbol}, got
Array{*
*Array{Symbol,1},1}*
* in (::Base.#kw##join)(::Array{Any,1}, ::Base.#join,
::DataFrames.DataFrame, ::D*
*ataFrames.DataFrame) at .\<missing>:0*
Any help would be appreciated.
